Posted to microsoft.public.excel.programming

Stephen Newman[_2_] Stephen Newman[_2_] is offline

external usenet poster

Posts: 18

TextBox Event Error

Could somebody explain why this throws an error please?

Private Sub TextBox1_Change()
i = 1
MsgBox TextBox & i & .Value
End Sub

I get this error at .Value:

Compile error:
Invalid or unqualified reference.

If posible, could the correct syntax for writing this be provided?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Exit event/textbox/frame	Flemming JÃ¸rgensen[_2_]	Excel Programming	3	May 16th 08 12:38 AM
Textbox.change event not firing!	Craig M	Excel Programming	0	October 3rd 06 04:30 AM
How To Get An Event To Run When I Exit A TextBox	Minitman[_4_]	Excel Programming	7	October 22nd 04 11:27 PM
help with textbox change event	N E Body	Excel Programming	1	October 14th 04 10:07 PM
Textbox change event	Ian Mangelsdorf	Excel Programming	2	April 17th 04 09:30 AM

All times are GMT +1. The time now is 07:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us