Enabling more than one option button

[Tempy]

Hi all,

Once again thanks for all the help.

My next problem is that i have 3 frames and each frame has about 6
option buttons in. The problem is that i would like to have a reset
button that will reset all option button at once.
Would one have to put under the reset button

OptionButton_905.enabled = True

For each option button or is there shorter code that will do them all ?

Tempy

*** Sent via Developersdex http://www.developersdex.com ***

 

[Tom Ogilvy]

Dim cntrl as control
for each cntrl in Userform1.controls
if typeof cntrl is MSforms.OptionButton
cntrl.Value = False
end if
Next

 

[Bob Phillips]

18 buttons is not that many when you copy and paste, and then just change
the number.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tempy]

Thanks so much Thom,

Have a great weekend, i am almost outa here !!

It is 15:50 here.

Tempy

*** Sent via Developersdex http://www.developersdex.com ***