 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2008uncheck a checkbox with a macro
I need a macro to delete information in cells (A2:G2), and change the value of a check box to false. The check box is linked to cell (E2) and the value should change to false. The check box was created useing the forms tool box. Thanks! Sub whatever Range("A2:G2").ClearContents end sub  SignatureHTH... Jim Thomlinson > I need a macro to delete information in cells (A2:G2), and change the value > of a check box to false. The check box is linked to cell (E2) and the value > should change to false. The check box was created useing the forms tool box. > Thanks! hi just to add to jim's responce... Sub whatever Range("A2:G2").ClearContents Range("E2").value ="False" end sub regards FSt1 > I need a macro to delete information in cells (A2:G2), and change the value > of a check box to false. The check box is linked to cell (E2) and the value > should change to false. The check box was created useing the forms tool box. > Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.