Worksheet Shape [textbox] Selection Event

[CPWilson]

Hi,

I have a worksheet with several text boxes, and when a specific text box is selected, I would like to run a macro. Much like what you might do using the Worksheet_Selection Change function.

But, the Worksheet_Selection Change function seems to only respond to cell selection changes, not to shape or text box selection changes.

Appreciate any help!

 

[VoG]

Hello and welcome to MrExcel.

If you right click a text box you should get the option Assign Macro.

 

[CPWilson]

Hi, I'm using 2003 SP3, when I right click on the text box, I do not have the assign macro option displayed. Perhaps that is in the newer version?

Thanks!

 

[CPWilson]

Did a bit more research and I get the _change and _Enter events to work, but when I try the _mousedown event, I get a "Procedure Declaration Does Not Match Description of Event" error.

Any ideas?