View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lou Lou is offline
external usenet poster
 
Posts: 5
Default Validateing a txtbox from form

I have a form that has textbox txtAN after the cmbbutton is clicked I want to verify that the information in the txtAN box is 5 numbers. It has to be 5 number no more/no less and no alpha charecters. How do you make this check occure

If txtAN < 5 Then GoTo errmsgbx Else I started with this but this is not correct. Any help would be great thanks.