Checking to see if user selected an Option

  • Thread starter Thread starter Kirk
  • Start date Start date
K

Kirk

I have a spreadsheet that has form that pops up requiring
a user to input 3 fields into 3 different text boxes. On
top of that the user is expected to select a specific
option out of 7 options that reside within a frame.

How is it possible to validate that the user selected one
of the options? I have checks in place for the input
boxes, but I can't seem to figure out a way to check that
an option has been selected upon hitting the OK button.

Any ideas?

Any help would be appreciated. Thanks.

Kirk
 
Kirk,

Try something like

Select Case True
Case CheckBox1.Value
MsgBox "1"
Case CheckBox2.Value
MsgBox "2"
Case CheckBox3.Value
MsgBox "3"
End Select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Option Box on user from to update workbook 6
Remove a criteria from countif based on user selection 5
Bizarre option button behavior 2
Option Buttons and Combo Bars 7
Checking to see if a user form is hidden 5
What are the steps to fix damaged MDF files in SQL Server? 0
Option Button versus Check Box 3
Frontpage 2000 - Going to a new page from a value in a drop-down box 0

Back
Top