Dave Peterson
12/19/2006 11:12:00 PM
Sorry, it was a typo on my part:
set myBTN = activesheet.buttons(application.caller)
You can get the name directly from application.caller, but by using the myBTN
variable, you can get other stuff, too:
msgbox mybtn.topleftcell.address
for instance.
Tsjaikovski wrote:
>
> I got a the following error on line 1
> set myBTN = activesheet(application.caller)
>
> "Object doesn't support this property or method"
>
> Do I have to referene the application.caller somewhere?
>
> Object doesn't support this property or method
>
> "Dave Peterson" wrote:
>
> > 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
> >
--
Dave Peterson