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