Add a Button To Excel to Run a Macro

mtgingrass

2017/10/03

Adding Button for GUI Interface.

Now that you have a few macros under your belt (some from scratch, some recorded, and some cut/pasted from the internet), it’s time to make a user interface for them.

In this tutorial, I will show you how to insert a simple button control to activate your macro. This is a very easy process and it will save you from having to explain to users how to get into the VBA editor.

In this tutorial you will learn:

Watch this short video for a step by step guide.

[embed]https://youtu.be/CH5PHJ5bcwA[/embed]

Need a Macro to try this one? No problem. Cut and paste this oneto get you started.

Share your button tips and tricks in the comments below. I’m curious to see what kind of macros you have created.

comments powered by Disqus