View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
FuriaRi0T FuriaRi0T is offline
external usenet poster
 
Posts: 6
Default 'Uncheck button'

It doesn't appear to have worked. If I'm supposed to manipulate the code in
someway, pardon my 'green horn'ness, but I'm not sure how.

"Leith Ross" wrote:

On Jul 26, 8:52 pm, FuriaRi0T
wrote:
Just the checkmark itself, not the actual boxes.

"OssieMac" wrote:
Do you mean that you want to remove the check boxes altogether or simply
remove the check mark from the boxes?
--
Regards,


OssieMac


"FuriaRi0T" wrote:


sorry for the double post - my browser crashed mid-post!


"FuriaRi0T" wrote:


I've made an 'uncheck button' within Excel... I want this button to remove
all checkboxes on the page. How would I go about doing this? There are 112
checkboxes in which the button would need to remove.


Hello FuriaRiOT,

If the Check Boxes are the Forms type and located on the same
worksheet then you can attach this macro to your button. Copy this
code to a standard VBA module in your workbook's VBA project.

Sub ClearCheckBoxes()

Dim ChkBox As Object

For Each ChkBox In ActiveSheet.CheckBoxes
ChkBox.Value = xlOff
Next ChkBox

End Sub

Sincerely,
Leith Ross