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
*****************************************
|