Command button on worksheet

[Guest]

I'm relatively new to Excel VBA.

I've added a command button to a worksheet, which I want to use to open a
userform. The code behind the button works (used debug to make sure), but I
cannot get the Click event of the button to work on the spreadsheet. When I
click on the button, it just selects it for editing.

Dale

 

[Guest]

Disregard!

Apparantly, all I had to do was close the workbook and open it again.

Duh!

 

[Shrubz]

Hi Dale,

Try taking it out of Design Mode. On Control Toolbox Menu, click on
Design Mode.

See if that works

Paul

 

[Guest]

Also, there is an icon that looks like a carpenters square and a pencil,
under the toolbox toolbar, it toggles between desing mode and exit desing
mode. So you don't necessarily need to close the book.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.

 

[Guest]

Dale

I wouldn't go as far as saying "Duh".

The reason for the "selection" is that you were in Design mode - next time
click on the triangle in the left hand corner of the "control toolbox".

Mistakes like this are quite common in an Excel environment - live with it.

Regards

SysAccountant