424 error

[jr]

I'm doing VBA in Excel 2004 on a form. This code gives me a 424
undefined object. I guess that means it wants me to define the
textbox control?


Private Sub CommandButton1_Click()
Dim players As Variant
players = Array("Dan", "Fred", "Bart", "Carlos", "Ty", "Juan", "Jay",
"Sam", "Pedro")
Dim i As Integer
i = CInt(texbox1.Text)
MsgBox (players(i) & " is on first base")
End Sub

thanks,

 

[JE McGimpsey]

I'm doing VBA in Excel 2004 on a form. This code gives me a 424
undefined object. I guess that means it wants me to define the
textbox control?


Private Sub CommandButton1_Click()
Dim players As Variant
players = Array("Dan", "Fred", "Bart", "Carlos", "Ty", "Juan", "Jay",
"Sam", "Pedro")
Dim i As Integer
i = CInt(texbox1.Text)
MsgBox (players(i) & " is on first base")
End Sub

Do you have a textbox control on your userform named "texbox1" (i.e.,
not "textbox1")?

 

[jr]

Do you have a textbox control on your userform named "texbox1" (i.e.,
not "textbox1")?

Yeep. I changed it to textbox1 and it works better except now I get a
type 13 mismatch?
thanks,

 

[JE McGimpsey]

Yeep. I changed it to textbox1 and it works better except now I get a
type 13 mismatch?

That would indicate that the Text in textbox1 can't be interpreted as
numeric.

 

[jr]

That would indicate that the Text in textbox1 can't be interpreted as
numeric.

I guess I better get VB.net instead of Excel 2004.
tnx,

 

[JE McGimpsey]

That would indicate that the Text in textbox1 can't be interpreted as
numeric.

I guess I better get VB.net instead of Excel 2004.[/QUOTE]

That seems rather a non-sequitur. What is the text in your textbox?