Now you can type within the text box shape. right-click on the shape and then click on Edit Text. You can type any text within the shape to make it more intuitive (such as ‘Click here to run the macro’).
![spin button excel change color spin button excel change color](https://www.excel-easy.com/smi/vba/examples/spin-button-2.png)
which indicates that now this shape has become clickable.Īnd now if you click on the shape, it will run the assigned macro. Now when you hover the cursor over the shape, it will show the hand icon. The selected macro has now been assigned to the shape. In this example, I will click on the macro named ‘GoodMorning
#SPIN BUTTON EXCEL CHANGE COLOR HOW TO#
Now let’s see how to assign a macro to this shape. I prefer using a rectangle and it looks like a button and is more intuitive. Note that I have inserted a rectangle shape in this example, but you can insert whatever shape you want (such as a circle or triangle or arrow).
#SPIN BUTTON EXCEL CHANGE COLOR PLUS#
You will notice that your cursor changes to a plus icon In Shapes options, click on the Rectangle option.
![spin button excel change color spin button excel change color](https://images.saymedia-content.com/.image/t_share/MTc2MjYwNDA2NDA5NDM4Mzk4/using-form-controls-and-activex-controls-option-buttons-or-radio-button-in-excel-2007-and-excel-2010.png)
In the illustrations group, click on Shapes.
![spin button excel change color spin button excel change color](https://contexturesblog.com/wp-content/uploads/2018/10/halloweenpicture05_thumb.png)
You can easily insert a shape (square or rectangle) and can make it look like a button.Īnd since it’s a shape, you can easily format it to look perfect with your existing formatting or brand colors.īelow are the steps to insert a shape in Excel: I personally love this method and prefer it over the rest two methods covered later. While there are dedicated buttons that you can insert in the worksheet and then assign the macro to it, I will first cover how to assign a macro to a shape. Insert a Shape and Assign Macro to that Shape