userform validation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

O''Dell - 05 Mar 2008 20:43 GMT

Hi,

I have a userform with several text and combo boxes. The last object on the
page is an optionbutton. How do I force the user to fill in all the
text/comboboxes before allowing the option button to be selected? The
optionbutton will open another userform and I'd like the first form to be
complete prior to opening the second.

Thanks-
O'Dell

Reply to this Message

fumei - 05 Mar 2008 20:59 GMT

This is a logic and design question.

What is an "optionbutton"? Never heard of one. Commandbutton, yes.

"to be selected" - this is part of the logic issue. If what your
optionbutton is, is actually a CommandButton, then you can start your logic
when it executes....not when it is selected.

CommandButton_Click()
check all the stuff needed to check
IF everything OK THEN
open other userform
ELSE
set focus on offending missing whatever
END IF

"How do I force the user to fill in all the text/comboboxes before allowing
the option button to be selected?"

By checking them, and seeing if they are filled in.

>Hi,
>
[quoted text clipped - 6 lines]
>Thanks-
>O'Dell

Reply to this Message

ODell - 05 Mar 2008 22:54 GMT

Fumei,
Thanks for your reply.
I have three Optionbuttons (from userform toolbox) in a frame, not a command
button. Only one can be "selected" or chosen. I will apply your advice to
use the "If/Then" logic and see how it goes. One follow up question...how
would I set the focus on an empty text/combo box?

O'Dell

> This is a logic and design question.
>
[quoted text clipped - 27 lines]
> >Thanks-
> >O'Dell

Reply to this Message

Doug Robbins - Word MVP - 07 Mar 2008 11:55 GMT

[Controlname].SetFocus

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Fumei,
> Thanks for your reply.
[quoted text clipped - 42 lines]
>> >Thanks-
>> >O'Dell

Reply to this Message