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

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



.

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



.

.