View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Clear All Checkboxes?

I'm developing a fairly complex Userform with 8 checkboxes. Is there a way to
control all boxes with one command. Say for example the end user selects 6 of
the 8 boxes, then clicks run and then excel does its thing. My question is,
is there anyway to clear all the checkboxes with one line, instead of
checkbox1.value = false, checkbox2.value = false, etc...? Or another example
would be if none of the checkboxes are selected then my msgbox would appear,
but be able to do this in one line. I just want to simplfy the code from 8
lines to 1 line. Thanks.