Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Required Fields for many Text boxes on a userform
Try this: for each textbox that you want to check create a change
event function that calls another function to test if Len$ (textboxControl.Text) = 0 or not. If you don't want the "next" or "finish" button to be enabled (btnControl.enabled = false or true) until the user enteres data into all the required fields you can create a function that checks the Len$ (textboxControl.Text) = 0 for all of the controls and only if all of the. The function would be called again from the _Change() events. Hope that helps. On Apr 22, 8:52 pm, Carlee wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validating Required Fields in Userform | Excel Discussion (Misc queries) | |||
Make text cells and combo boxes required? | Excel Discussion (Misc queries) | |||
Userform text & combobox population help required please | Excel Programming | |||
userform text boxes | Excel Programming |