Userforms/Multipage- Disabling next button unless option buttons selected

Question

I have a multipage userform including entry details page and am using "NEXT" button to move onto next pages. ( There are 5 question pages + 1 entry detail page) Here is the code that I am using to navigate.

If QuestionairePages.value < QuestionairePages.Pages.Count - 1 Then
    QuestionairePages.value = QuestionairePages.value + 1

End If

Is there a way to disable the moving to the next pages unless all options buttons selected on specific pages?

Sheet? I am moving to next page which includes other additional option buttons — mesakon
You can just utilise another if-statement IF Option1.Value = FALSE and Option2.Value = False Then MsgBox "Please complete the form" ELSE [the code in the question] I am unaware of a better way to assign option groups for form validation — Glitch_Doctor
Are your OptionButtons grouped? With selected you mean "ticked"? — EvR
@Glitch_Doctor The problem is my questions (option buttons) are starting at 3rd page, and message boxing popping up from first page to option buttons. — mesakon

JC Guidicelli JC Guidicelli · Accepted Answer · 2018-07-03T13:00:03

I don't have enough information to write exactly what you need, but you can try with the .visible command and with the boolean on the option button like this :

If YourOptionButton1 = true then
 YourButtonNext.Visible = False
End if

Userforms/Multipage- Disabling next button unless option buttons selected

1 Answers