ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   For Each Function?? (https://www.excelbanter.com/excel-programming/335416-each-function.html)

Dave_2k5

For Each Function??
 

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


Bob Phillips[_6_]

For Each Function??
 
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 :confused:


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





All times are GMT +1. The time now is 02:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com