View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eliezer Eliezer is offline
external usenet poster
 
Posts: 12
Default Excel VBA array of checkboxes

I have 44 checkboxes on a VBA Excel form that I dragged
there from the Toolbox. I named them all rep1_cb,
rep2_cb, rep3_cb, ... rep44_cb.

I want to add a button to the forum to un/check all
checkboxes within this "group". Is there some way to
store them all within an array - or create some sort of
loop without having to individually change the value of
each and every one of them?

Thanks!
Eliezer