Userform, all fields required
 

Hi there,

I have a user form containing about 75 combo boxes. All cbo's require data
to be entered prior to the user submitting to the sheet log.

Question: Is there a script that loops through all fields and displays a
message if any boxes are missing data?

--
Carlee

Userform, all fields required
 

Dim ctrl as Object
for each ctrl in Userform1.Controls
if typeof ctrl is msforms.combobox then
if ctrl.Value = "" then
msgbox "Missing Data in " & ctrl.Name
exit sub
end if
end if
Next

--
Regards,
Tom Ogilvy

"Carlee" wrote:

Hi there,

I have a user form containing about 75 combo boxes. All cbo's require data
to be entered prior to the user submitting to the sheet log.

Question: Is there a script that loops through all fields and displays a
message if any boxes are missing data?

--
Carlee