Multiple Checkboxes

[tmleynek]

Hi All,

I have approximately 4 checkboxes on a userform template that when I hit a command button, whichever four boxes are clicked "True" would populate into a bookmark named "Clients"

My issue here is the punctuation if more than 1 and 2 boxes are checked. My four boxes are Client 1, Client 2, Client 3, and Client 4.

If only Client 1 is checked true, -- "Client 1" would populate
If Client 1 and 2 are checked true, "Client 1 and 2" would populate
If Client 1, 2 and 3 are checked true, "Client 1, 2, and 3" would populate....

And so on.

Please let me know if there is an easy fix to this.

Thank you!

[macropod]

What is the code you are using?

[tmleynek]

I have no code right now, I'm not 100% sure even where to start. I'm assuming it could be IF statements:

(IF AND checkbox1 = Client 1 checkbox2 = Client 2) THEN "Client 1 and Client 2", (IF AND checkbox 1 = Client 1, checkbox 2 = client 2, checkbox 3 = client 3) THEN "Client 1, Client 2, and Client 3"

I dont necessarily want 16 statements though.

[macropod]

Can any checkbox be checked at random, or do they need to be checked in sequence?

[tmleynek]

Can any checkbox be checked at random, or do they need to be checked in sequence?

The checkboxes can be checked at random.

[macropod]

I seem to have missed your reply. Given that the checkboxes can be checked at random, are the data to be inserted in the order in which the checkboxes are checked, or in a pre-defined order?