I am buliding a questionnaire using Excel and I am using option button
and text boxs. I want to have a reset button which changes all th
option button values to false and the text boxes to nothing ("").

I don't want to have a really long code, One line for each optio
button, as there are over 50 option buttons.

I have had a look at trying to do a For Each Statement, but couldn'
get it to work...Please Help!!!

Cheers,

Dave :confused

--
Dave_2k
-----------------------------------------------------------------------
Dave_2k5's Profile: http://www.excelforum.com/member.php...fo&userid=1966
View this thread: http://www.excelforum.com/showthread.php?threadid=38983

see response in other group.

--

HTH

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


"Dave_2k5" wrote in
message ...

I am buliding a questionnaire using Excel and I am using option buttons
and text boxs. I want to have a reset button which changes all the
option button values to false and the text boxes to nothing ("").

I don't want to have a really long code, One line for each option
button, as there are over 50 option buttons.

I have had a look at trying to do a For Each Statement, but couldn't
get it to work...Please Help!!!

Cheers,

Dave


--
Dave_2k5
------------------------------------------------------------------------
Dave_2k5's Profile:
http://www.excelforum.com/member.php...o&userid=19667
View this thread: http://www.excelforum.com/showthread...hreadid=389834