Excel VBA Macros
In this chapter let us understand how to write a simple macro. Let us take it step by step.Step 1. First let us enable 'Developer' menu in Excel 20XX. To do the same, click on File >> Options.
Step 2. Click Customize Ribbon Tab and check 'Developer' and click 'OK'.







Private Sub say_helloworld_Click() MsgBox "Hi" End SubStep 10. Now you can click the button to execute the sub-procedure. The Output of the sub-procedure is shown below. We will demostrate further chapters using a simple button as explained from step#1 to 10. Hence It is important to understand this chapter thoroughly.

Post a Comment