View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zak Zak is offline
external usenet poster
 
Posts: 144
Default Validation on text input boxes on a form

Hi

I was wondering if anyone can let me know how to add validation to text
input boxes on forms?

I have several forms on a spreadsheet that I am creating and there are quite
a few time and date input boxes, which I was hoping I could add validation to
so that the information is entered in the correct format? i.e. date should
only be in dd/mm/yy, time should only be entered like hh:mm etc.

Can this be done?