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

--
Regards,
Tom Ogilvy


"Tempy" wrote in message
...
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 ***