Try

Dim BT As Excel.Button
Set BT = ActiveSheet.Buttons(Application.Caller)
MsgBox BT.Text



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Andy Warner"
wrote
in message
...

I've now found

application.caller

which tells me which button ran the macro.

I want the .text of that button. I was hoping:

myString = Application.Caller.Text

or

myButton="["+Application.Caller+"]"
myString = myButton.Text

would work, but they dont. any further???


--
Andy Warner
------------------------------------------------------------------------
Andy Warner's Profile:
http://www.excelforum.com/member.php...o&userid=31363
View this thread:
http://www.excelforum.com/showthread...hreadid=534515