View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carlee Carlee is offline
external usenet poster
 
Posts: 155
Default Required Fields for many Text boxes on a userform

Hi there,

I have user form containing approximately 90 textboxes, spread over 5 tabs.
75 of these fields are required for data entry.

Question:
Is there a function that i can use, and call on each text box, that checks
to see if the required fields on each tab contain data in it. if it doesn't,
i want to present a message to the user listing the fields that need to be
completed before the submission can be completed successfully, or the user
can move to the next tab.

Any ideas?
--
Carlee