| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Buttons on User Forms
If I have 4 option buttons on a user form withing a frame (which makes them
mutually exclusive), what kind of code can I write to tell me which option button was pressed. Assume that they are named: opt1, opt2, opt3, opt4 Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Option Buttons on User Forms
Select Case True
Case Me.Opt1.Value ... Case Me.Opt2.Value ... Case Me.Opt3.Value ... Case Me.Opt4.Value ... End Select "ibeetb" wrote in message ... If I have 4 option buttons on a user form withing a frame (which makes them mutually exclusive), what kind of code can I write to tell me which option button was pressed. Assume that they are named: opt1, opt2, opt3, opt4 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option Buttons from the Forms Toolbar - Excel 2003 | Excel Worksheet Functions | |||
| Forms Option Buttons(Can be right mouse selected when sheet is loc | Excel Discussion (Misc queries) | |||
| User forms "back" buttons | Excel Discussion (Misc queries) | |||
| Forms: Group Boxes and Option Buttons | Excel Programming | |||
| Command Buttons on XL User Forms | Excel Programming | |||
Hybrid Mode
