Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a textbox called txtStartLotNumber on a form called frmLotNumber. That's all that's on the form, along with an OK and Cancel button. When user enters into textbox, and clicks OK, in need to verify the entry, before the rest of the code in the OK button executes. The entry has to be: - A six digit number OR -A five digit number, preceeded by an 'M', or an 'S', or a 'R' If those conditions are met, the sub continues, If not, a message indicating an 'Invalid Entry' displays, then cycles back (a loop?) to the frmLotNumber to reenter a valid lot number. As usual, Thanks for any help! -Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Textbox Clear last entry | Excel Programming | |||
column of entry for textbox value | Excel Programming | |||
Validate textbox entry | Excel Programming | |||
Validate Textbox entry | Excel Programming | |||
Validating Entry into Textbox | Excel Programming |