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