Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
GroupName
Hi, using XL 2000.
I have specified 10 optionbuttons (OptionButton1 - OptionButton10) and assigned the groupname 'Test' to each. I need to assign a command button which will 'reset' the value of each OptionButton to False. I could do this for each OptionButton but I figured there must be a simplified routine that could accomplish this. Any Ideas? Many thanks, Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
GroupName
loop through the Controls collection
if your controls have a name beginning with say 'opt' then your loop could be dim ctrl as control For Each ctrl in Controls if left(ctrl.name,3)="opt" then 'reset the control here end if Next Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi, using XL 2000. I have specified 10 optionbuttons (OptionButton1 - OptionButton10) and assigned the groupname 'Test' to each. I need to assign a command button which will 'reset' the value of each OptionButton to False. I could do this for each OptionButton but I figured there must be a simplified routine that could accomplish this. Any Ideas? Many thanks, Paul . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
GroupName
Many thanks for your solution Patrick.
Works fine. -----Original Message----- loop through the Controls collection if your controls have a name beginning with say 'opt' then your loop could be dim ctrl as control For Each ctrl in Controls if left(ctrl.name,3)="opt" then 'reset the control here end if Next Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi, using XL 2000. I have specified 10 optionbuttons (OptionButton1 - OptionButton10) and assigned the groupname 'Test' to each. I need to assign a command button which will 'reset' the value of each OptionButton to False. I could do this for each OptionButton but I figured there must be a simplified routine that could accomplish this. Any Ideas? Many thanks, Paul . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|