| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validate an option is chosen
Worked great, Much appreciated.
-----Original Message----- You can validate the values by nesting IF Statements at the beginning of your code... HTH Owen If Sheet1.OptionButton1 = Sheet1.OptionButton2 Then If Sheet1.OptionButton2 = False Then Dim lMsg As Long lMsg = MsgBox("Select an Option Fool", vbOKOnly + vbExclamation, "No Selection Made") End If End If -----Original Message----- I have 2 option buttons in a form. The worksheet is emailed with a macro. How can I validate in my macro that one of the option buttons has been selected. In other words I would like a message box to pop up saying "You must make a selection before emailing" if the user does not select one of the option buttons. thanks . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter rows on sheet 2 when a certain option is chosen on sheet 1 | Excel Worksheet Functions | |||
| Formula to point to another cell if an option is chosen. | Excel Worksheet Functions | |||
| Font different than one chosen | Excel Discussion (Misc queries) | |||
| How do I let only one box be chosen when there are several? | Excel Worksheet Functions | |||
| User Option to save to chosen destination | Excel Programming | |||
Hybrid Mode
