Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Controlling an Option Group in a User Form
Hi,
I have a User Form with 3 Option Buttons enclosed in a Frame. The Option Buttons all have the GroupName = grpMeas. None of the controls are overlapping. I want to be able to set the group value with a single command maybe something like: ufrmFSFShtControls.fraMeas = 2 'set the second opt btn true, first and third false OR ufrmFSFShtControls.grpMeas = 2 I can't seem to figure out how to do this and it's a big problem because the controlling the opt btns individually causes a huge mess in managing the Change events of the controls. Thanks in advance for any help you can provide. Best Regards, Dean Code Excerpt, How I dimensioned the controls ***************************************** 'dimension variables Dim ctloptMeas(1 To 3) As Control 'instantiate the control variables Set ctloptMeas(1) = ufrmFSFShtControls.optMeas1 Set ctloptMeas(2) = ufrmFSFShtControls.optMeas2 Set ctloptMeas(3) = ufrmFSFShtControls.optMeas3 ***************************************** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form: Cannot Update Text Box | Excel Discussion (Misc queries) | |||
user form related | Excel Discussion (Misc queries) | |||
Want to get user selections from a message box using option buttons | Excel Discussion (Misc queries) | |||
user form | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |