Thread: validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default 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