Shortening up Code

Hi

Here a possibility.

I've assumed that the default for an array is used (ie 0) but if you want to set the array base index then use the

Please Login or Register  to view this content.

statement to determine what starting number you want to use. If you change the base to 1, then change the +35 to +34.

Please Login or Register  to view this content.

I'm guessing that the items are checkboxes, but I don't know where they are. If on a sheet then the above may work (didn't test....), but if on a form then you will have to rejig along the lines of

Please Login or Register  to view this content.

Hope that gives you some ideas.

rylo

Hello Rylo,

The code snippet is for part of a userform, and yes the code shown is for multiple checkboxes I have on the userform. The code in it's entirety seems to long (at least it appears long to me and thats why I didn't paste it), anyways - I was looking for a way to simplify things, starting with the checkboxes. I'll definitely give your advice a try. Thnx again.