Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validation
hello all,
i am trying to put validation on a textbox in a userform. i currently have this bit of code and it does not work. all i need is for it to except a 0 or 1 anything else would produce a message box stating that a 0 or 1 is needed. Private Sub nailbase_Change() If nailbase.Value 1 Then MsgBox "Number must be a 0 or 1." End Sub -- Thank You in advance, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |