Thread: help with textbox change event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kkknie[_231_] kkknie[_231_] is offline
external usenet poster
  
Posts: 1
Default 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 QuoteReply With Quote