UserForm make option button and textboxes mandatory

[Xalova]

Okay. So i have created a userform with several textboxes and optionbuttons.

What i have achieved until now is that ceartain textboxes are mandatory and have to be filled. But i dont seem to get it with the optionbuttons and i dont know why.

the if statement is as follows:

If Me.ADA.Value <> "" And Me.datummat.Value <> "" And Me.KommNr.Value <> "" And Me.Empfänger.Value <> "" And Me.Artikel.Value <> "" And (Me.Ausgabe.Value = "wahr" Or Me.Rücknahme.Value = "wahr") Then

now you may think that the statement

Me.Ausgabe.Value = "wahr"

could be the error. But i have tried the whole if statement without the textboxes and it worked as i wanted it to work, so it shouldnt be the error, right?

i dont know how i solve this problem. I need help.

 

[My Aswer Is This]

On a Userform typically only one Option Button can be selected.
Unless you have them in Frames.

 

[Xalova]

On a Userform typically only one Option Button can be selected.
Unless you have them in Frames.

i mean yes, but i want to kinda "force" the user to select an option button.

kinda like
"do not accept if no optionbutton is selected"

do you get what i mean?

 

[dmt32]

i mean yes, but i want to kinda "force" the user to select an option button.

kinda like
"do not accept if no optionbutton is selected"

Try adding line like following & see if does what you want

'both optionbuttons False
If Not Me.Ausgabe.Value And Not Me.Rücknahme.Value Then MsgBox "Selection Required": Exit Sub

Dave

 

[Xalova]

Try adding line like following & see if does what you want

'both optionbuttons False
If Not Me.Ausgabe.Value And Not Me.Rücknahme.Value Then MsgBox "Selection Required": Exit Sub

Dave

sadly this did not work.

also i need it in ADDITION to textboxes, which have to be filled.

 

[dmt32]

sadly this did not work.

also i need it in ADDITION to textboxes, which have to be filled.

Not sure why - if both OptionButtons are False should display the msgbox & exit sub

Helpful if you can post all the code for forum to give better idea of what you are doing.

Dave