Create a procedure
Code within a module is organized into procedures. A procedure tells the application how to perform a specific task. Use procedures to divide complex code tasks into more manageable units.
To create a procedure by writing code
Open the module for which you want to write the procedure.
Type Sub, Function, or Property. Press F1 to get Help with syntax, if necessary.
Type code for the procedure. Visual Basic concludes the procedure with the appropriate End Sub, End Function, or End Property statement.
To create a procedure by using the Insert Procedure dialog box
Open the module for which you want to write the procedure.
On the Insert menu, click Procedure.
Type the name for the procedure in the Name box of the Insert Procedure dialog box.
Select the type of procedure you want to create: Sub, Function, or Property.
Set the procedure's scope to either Public or Private.
You can select the All Local Variables as Statics to add the Static keyword to the procedure definition.
Click OK.
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om