VBA code for adding a commandbutton

[ben_sumner]

I need the code to add a commandbutton. What I need to do do is add a command button for each of the sheets. At the moment there are 8 sheets so there wil need to be 8 commandbuttons. But this can change from time to time. So I have written a procedure that will add the correct amount of commandbuttons in the corect places. Now all I am missing is the code to create the commandbutton. Can anyone help??


Ben

[mudraker]

Is this what you are after?

Please Login or Register  to view this content.

[ben_sumner]

It works perfectly but I forgot to mention that I wanted to add it to a form (say OverviewForm) not a sheet. if you help me with that it would be great


Thanks Heaps
Ben

[mudraker]

Took me a while to track it down

Have a look at

http://www.mrexcel.com/archive/Controls/111.html

Especially the part dated October 08, 2001 12:42 AM