How to Create a Macro Button In Excel 2003 & Excel 2010

After creating your first few macros you will likely grow tired of running them through the traditional user interface. Luckily for you, Microsoft has included a handy feature that allows you to create a button on your spreadsheet and assign your macro to run when it is clicked.

It's not hard to insert a button, once you get the hang of it, but it can be a little tricky the first few times.

In both Excel 2003 and 2010 buttons are located on the forms toolbar, however finding the toolbar is a little different in each. I have recorded two videos to illustrate the process of inserting a button and assigning a macro in Excel 2003 and Excel 2010 respectively.

• Record a Macro in Excel 2003 & Excel 2010
• A Tour of the VBA Enviornment in Excel

The next module is on VBA variables. Click here when you are ready to proceed.