Reading the button text for excel 2003 1

[jaeyoo]

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 to work on excel 2003?

 

[SkipVought]

Hi,

How about the Caption property of the button control?

Skip,

_[red][/red]

 

[jaeyoo]

How do i do that?

 

[SkipVought]

Sub MyButton_Click()
   sText = MyButton.Caption
End Sub

If your button is on a Sheet object, then you are ALREADY on the Sheet.

If your button is on a UserForm, then how do you know what sheet to go to?

Skip,

_[red][/red]

 

[jaeyoo]

Thank you I'll go try it

 

[jaeyoo]

Didn't work....

Sub MyButton_Click()

Dim sText As String
Dim x As Integer

x = 0
sText = MyButton.Caption
End Sub

 

[SkipVought]

Do you have a button named MyButton?

It's gotta be in the CLICK event for an existing button.

Skip,

_[red][/red]

 

[jaeyoo]

Thank you I figured it out