![]() |
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 |
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