Hi,
I'm trying to make my macro read the button text to go to the sheet name that's on the button and for excel 2000
text = ActiveSheet.Button(Application.Caller).Characters.Text
this used to work but for excel 2003 this doesn't work anymore. please help what changes do i have to make for it...
How do I create custom captions for MSGbox buttons?
I want to add three of my own buttons but MSGbox doesn't let you change the captions on the buttons.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.