View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SaeOngJeeMa SaeOngJeeMa is offline
external usenet poster
 
Posts: 21
Default 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

*****************************************