Buttons

[Dave]

Hi,
XL2003
I have some buttons on the Worksheet (from the Forms toolbar) which fire
specific macros.
Can VBA return (to a variable) the text of the button that fired it?
Regards - Dave.

 

[Tim Williams]

Application.Caller will give you the name of the button.

You can get the text using the name.

Tim

 

[Dave]

Hi Tim,
Thanks for your help. But still stuck.
I have:

A = Application.Caller
B = ActiveSheet.Shapes(A).Characters.Text

The first line is working.
But the second line gives an error. Can you please point me to the right
syntax?
Regards - Dave.

 

[john]

see if this works for you.

A = Application.Caller
b = ActiveSheet.Buttons(A).Characters.Text

 

[Dave]

Hi John,
Thanks! When I modified the button with the macro recorder turned on, the
syntax used 'Shapes', But 'Buttons' works and Shapes doesn't, so pooh to the
macro recorder, and hats of to you.
Regards - Dave.