Excel 2010 VBA Tutorial 45 - Userforms - Option Buttons

How to use option buttons (AKA Radio Buttons)

[excelsocallmaster]

With the Next x after the first End If statement :-), Its easier to read if u have lots of optionbuttons in play. Although if that was the case then you would be better calling a class event on to trigger on click event....Excellent work with the videos it's great to see someone who puts time and effort into quality output

[cataleyalafleur]

Thank you very much for the explanation. Could you please create a video to include codes for how to update these options? Right now my options are working perfectly and I include a update/edit option on my form. I have the codes for updating textboxes, but I don't have one for options. Thank you.

[chriswright]

When I'm calling the question I get a compile error but if i remove quiz. before optionbutton(x) then it works? Is the quiz necessary have I missed something?

[chriswright]

Nvm I had renamed another form Quiz and it was trying to find the optionbuttons from that form instead

[excelsocallmaster]

Another method would be dim bAns as Boolean For x = 1 To 4....If me.optionbutton(x).value then....Answer = = True....End If...If Not bAns then msgbox "please choose an option" End If