controls in spreadsheets

[ridgetown_rick]

I have created a form in a worksheet. I would like to include a VB button that would run a macro once all the blanks are filled in. When I put a control button on the worksheet, it is just a dumb button (still in "design mode", if you will). How do I make it active so that when a user clicks on the button it runs off and does its thing?

 

[stevebausch]

While in Design Mode, right-click, select View Code, put your code there, or call the routine(s) from the routine that appears.

 

[ridgetown_rick]

Solved my own problem. Seems it works as expected when I grab the button from the forms toolbar - I was using the button from the controls toolbar.

 

[Andrew Poulsom]

Just for future reference, if you use a button from the Control Toolbox you need to click the first icon in the floating toolbar to exit (toggle) design mode. It looks like a geometry set.