View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Setting attributes for controls

Hi

There are checkboxes and checkboxes. The ones from the Forms toolbar are part of its
Checkboxes collection, so you can address #5 as Checkboxes(5). The ActiveX boxes from the
Controls toolbar are not, you have to deal with them one by one.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Don Madsen" wrote in message
...
If a sheet has CheckBox1 .....CheckBox20 and you want to program to hide
certain ones based on some criteria. For example, making CheckBox5 to
CheckBox9 Visible.False?