You can call the procedure using ‘Call’ Keyword as shown below.Ĭalling a Procedure in another Procedure: The following example shows how to call a sub procedure(FindSquare) from another Procedure(MainProcedure).Īssigning a Procedure to a Worksheet button or a Shape:Follow the below Steps to assign a procedure to a shape or button.
#WHAT IS A MACRO IN EXCEL 2003 CODE#
When You Double Click on the Command Button, it will open the code window with its event handler as shown below. We can also assign a shortcut key to a procedure and call it.Ĭalling a procedure using ActiveX Control – Command Button.
We can write and call Sub Procedures from another Sub Procedure, ActiveX Controls, or we can assign it to a shape or form button in a worksheet. MsgBox 'Square Value of a given number is: ' & i*i I=InputBox ('Please Enter a value to calculate square value:') Following is the programming structure of sub procedure:īelow is the simple sub procedure to accept values from the user and find its square value: We can write the Sub Procedures in any modules, Such as Code Module, Class Module,Forms and ActiveX Controls.Ī Sub procedure begins with a Sub statement and ends with an End Sub statement. Sub procedures are helpful to split a program into smaller piece of procedures. Generally sub procedures are called by using command button or by another sub procedure. Procedures in Excel VBA – What is a Sub Procedure?Ī sub procedure in VBA is a procedure that performs a specific task.Sub procedures are generally used to accept input from the user and do required action and then print the results. Examples on Sub Procedures – With and With Out Parameters.
0 kommentar(er)
