ensure user selects radio button before adding information

**JamesT1** · 05-27-2014, 07:57 AM

Good Afternoon folk

I have a userform for inputing information to a spreadsheet using the code below. It works fine however if the user does not select a radio button to select a score its saving the rest without it. How can I ensure the user selects a score,,,, ob10, ob8, ob6, ob4, ob2, obna

Please Login or Register  to view this content.

Many thanks for your help

**Tinbendr** · 05-27-2014, 08:44 AM

Please Login or Register  to view this content.

If you have more than one group of optionbuttons, then you could test for control names.

Please Login or Register  to view this content.

You can always set a optionbutton as a default when the userform starts.

Please Login or Register  to view this content.

**JamesT1** · 05-27-2014, 10:00 AM

Tinbendr

this is right on the button and exactly what I require, many thanks for your help, much appreciated

for anyone who needs something similar,,, this is the adjusted code

Please Login or Register  to view this content.

ensure user selects radio button before adding information

LinkBack

Thread Tools

Rate This Thread

Display

ensure user selects radio button before adding information

Re: ensure user selects radio button before adding information

Re: ensure user selects radio button before adding information

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Is there a way to add a button that selects the next checkbox in a row?

How do I lock a radio button group if a N/A button is selected

Prompting User to Select Radio Button

to ensure all radio button groups are used before moving on.

Pressing one radio button to select another radio button

Bookmarks

Bookmarks

Posting Permissions