View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
stefan onken stefan onken is offline
external usenet poster
 
Posts: 33
Default conditional validation

hi,
you could use code like this in TextBox2_Exit

If TextBox1 = "DUE" Then
If TextBox2 < "" Then
If TextBox2 < "1000" Then
MsgBox "enter 1000"
Cancel = True
End If
End If
End If

but this event fires only if you change to a control on the same page
of the multipage.
eventually, you need more/other events for the validation, e.g.
Multipage_Exit

stefan

On 9 Jun., 04:45, "tkraju via OfficeKB.com" <u16627@uwe wrote:
On a userform textbox1,in the same userform on *multipage 1 textbox2 is there.
I want to validate textbox2 : If textbox1 text is equal to "PAID" then entry
in textbox2 is not required,skip the entry and goto next tabstop.If textbox1
text is equal to "DUE",validate the textbox2 for a number(text) equal to 1000.