1. Learn VBA - Introduction to VBA Editor
Lesson 1 will teach you how to attach some code to a button that will bring up a message box that says Hello!.
Make sure your excel options (Office button in top left => Excel Options) are as shown:
Click Developer ribbon, Insert => choose the first button under "Form Controls".
Click and hold anywhere on your worksheet. Now drag the mouse down and across slightly. This will create the button. The further you drag, the bigger the button.
When the following box pops up, type: myMessageBox in the macro name field.
Now press NEW
You will now see a sub routine has been created for you, and you can type the following in the space provided:
Now press ALT + F11 to return to your sheet, and press the button.
Congratulations on writing your first VBA program !
Right click on an empty space on the toolbar, and choose FORMS.
...goto Step2 and continue.
Introduction to VBA Editor - Training Video