brisbane bob
Board Regular
- Joined
- Aug 9, 2007
- Messages
- 70
I've search Help without success - is there a command to clear all the checkboxes on a sheet? There must be....
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Newbie VB Macro query
- Thread starter brisbane bob
- Start date
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 63,880
- Office Version
- 365
- Platform
- Windows
brisbane bob
Maybe also put a command button on the sheet that runs this code:
<font face=Courier New><SPAN style="color:#00007F">Dim</SPAN> cb <SPAN style="color:#00007F">As</SPAN> OLEObject
<SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> cb <SPAN style="color:#00007F">In</SPAN> ActiveSheet.OLEObjects
<SPAN style="color:#00007F">If</SPAN> TypeName(cb.Object) = "CheckBox" <SPAN style="color:#00007F">Then</SPAN>
cb.Object.Value = <SPAN style="color:#00007F">False</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">Next</SPAN> cb</FONT>
Maybe also put a command button on the sheet that runs this code:
<font face=Courier New><SPAN style="color:#00007F">Dim</SPAN> cb <SPAN style="color:#00007F">As</SPAN> OLEObject
<SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> cb <SPAN style="color:#00007F">In</SPAN> ActiveSheet.OLEObjects
<SPAN style="color:#00007F">If</SPAN> TypeName(cb.Object) = "CheckBox" <SPAN style="color:#00007F">Then</SPAN>
cb.Object.Value = <SPAN style="color:#00007F">False</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">Next</SPAN> cb</FONT>
Upvote
0
