adding a command button to an excel cell?

B

betelguese

I've added a macro that runs vba code to perform some calculations. I wish
the user to click on a button in a cell on the worksheet to run this macro. I
am having trouble adding a command button to a cell? I have the control
toolbox up, but when i try to click on the command button or drag it to the
cell, nothing happens.
What to do?
 
G

Gary Brown

Left click on the command button on the control toolbox. Release the mouse
button. Move the mouse cursor to the cell you want to put the command
button. Left click and the command button should appear. Right click to
get to the popup menu that allows you to view code.
HTH,
Gary Brown
 
Top