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 ***************************************** |
All times are GMT +1. The time now is 09:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com