View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Uncheck every Check Box Q

Would there be a reason why the code below will not uncheck a Checkbox
that is "True" or ticked?


Sub UncheckBoxes()

Dim cb As CheckBox
Application.ScreenUpdating = False

Sheets("Input").Select
For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb

End Sub