Grabbing captions of checkboxes when true

[brujah]

Hi all,
I've managed to get so far, but am now stumped,... all i need to do is grab the captions of all checkboxes that have a value of true (checked)(there are 50 check boxes on the excel userform), and have that answer automatically concatenate (as it were) and fill in to a text box upon hitting the updateform button on the form I've created, eg 'caption1, caption6, caption34, caption 40, caption47' but i cant seem to get any further than it populating the very last value e.g.'caption47'...could some one please point me in the right direction on this?

Here is what i've got so far....

Please Login or Register  to view this content.

Any help getting this figured out would be greatly and grovellingly appreciated!!!!!
Thank you in advance!!!!!!
Brujah

[OnErrorGoto0]

Try this:

Please Login or Register  to view this content.

[brujah]

Rory, you are my hero, knew it had to be summit simple i was missin but nothing i tried worked... i is rubbish, and you are great!!! thank you so much, all doing exactly as i wanted now!!!

regards Brujah

[OnErrorGoto0]

My pleasure. Please don't forget to mark the thread Solved (see FAQ at top of the page)