PROBLEM: You already create macro then you need to run it with click on a button
SOLUTION: Use VBE (visual basic environment)
RESULT:
FOLLOW ME TO STEP-BY-STEP GUIDE
How to Assign Macro to a Button
1. Open your Excel.
2. Select Developer ribbon.
3. Click Insert component in Controls group and then click Button (see below)
4. Drag your cursor to create a button and release it. The Assign Macro window will appear (see below)
5. Click New button to create your Macro
6. You will entering a Visual Basic Editor (VBE) window and code SUB and END SUB automatically appear
7. Enter your code (for example I typed: MsgBox “Button is Clicked!!!”). This codes for showing a message box when it clicked. The message is “Button is Clicked!!!”. (See below)
8. Close your VBE window.
9. You will back to your Excel window and click to any cell to unselect the button.
10. Click your button and the message box will appear (see below)
Any questions?
