help with textbox change event
Hello
I dont even know if this is possible but here goes!
I am trying to block the user entering a number which begins with 0 (zero)
into the textbox.
Plain english version of code might be
Private Sub TextBox1_Change()
If First character in textbox is 0 then
MsgBox "choose a number NOT starting with 0"
Clear textbox
EndSub
Please dont mock my obvious lack of knowledge!!
Kenny
Excel 2000 and 97
|