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.
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기