Posted to microsoft.public.excel.programming

kkknie[_231_] kkknie[_231_] is offline

external usenet poster

Posts: 1

help with textbox change event

This should do it
Code
-------------------
Private Sub TextBox1_Change()
If Len(TextBox1.Text) = 1 Then
If TextBox1.Text = 0 Then
MsgBox "Choose a number NOT starting with 0"
TextBox1.Text = ""
End If
End If
End Su
-------------------

--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26936

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Action Event, CheckBox, Add Row and Textbox	Ryan	Excel Discussion (Misc queries)	2	July 17th 07 02:32 PM
How can I expose the TextBox BeforeUpdate event to my user class?	bereid	Excel Discussion (Misc queries)	0	November 30th 05 05:00 PM
Textbox change event	Ian Mangelsdorf	Excel Programming	2	April 17th 04 09:30 AM
MSForms.TextBox Exit event isn't available in Excel class mosule	lacos	Excel Programming	2	December 12th 03 10:12 AM
event which occurs when a TextBox receives focus	Mikhail	Excel Programming	2	October 7th 03 02:27 PM

All times are GMT +1. The time now is 03:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us