Name of button
these are buttons from the forms toolbar?
If you have a macro assigned to that button:
dim myBTN as Button
set myBTN = activesheet(application.caller)
msgbox mybtn.name & "- or - " & application.caller
Agamemnon wrote:
Hi
I have create a macro that put some buttons on a sheet.
As the buttons are created automatically I don't know what names they have.
So I would like to know how I can retrieve eg. in Cell sheet1!A1 the name of
the button I click on?
Can somebody help me out on this one?
Thx
--
Dave Peterson
|