Prompting User to Select Radio Button

Hi all,
How can I prompt a user with a msgbox when they forget to choose a radio button. The button is in a form and requires selection. Or, is there a way to have a radio button to be automatically chosen when the form loads? As it is, the radio buttons are blank upon load. There are 3 radio buttons for the user to choose from if that matters. I'm just looking for some sort of control on the situation if they forget to choose.

Sorry if the title is bad, I've been gazing at my computer trying to think of an appropriate title without much luck.

Thanks a million

Hello Mordred,

You can set the option button of your choice in the UserForm_Initialize() event module. The code below will set OptionButton1 when the UserForm is loaded.

Please Login or Register  to view this content.

Thanks Leith, that works quite well.