Userform: Have multiple checkbox values populate to one cell

[ciresuark]

Hello,

I am currently have a userform with 34 differnt check boxes. The check boxes are in a frame labeled as Codes. I currently have the code set up to enter the caption from the check box into a cell. If a user selects multiple check boxes, only one is currently entered into the cell.

The code I am currently using is:

Please Login or Register  to view this content.

Can this be modified to have multiple options put into (emptyRow, 7) separated by a comma?
I have searched the forum and other forums and found similar questions; however the code I have tried I am not able to manipulate to work with what I have.

Thank you for the help.

[judgeh59]

this may work....it is completely untested because I don't have a bunch of checkboxes....but I believe the theory is sounds....this should replace all the IF's...

Please Login or Register  to view this content.

[Norie]

Perhaps something like this.

Please Login or Register  to view this content.

[judgeh59]

my syntax won't work....Norie's looks like it will though....Go Norie

[ciresuark]

For Judgeh59:
I receive a run-time error '438': Object doesn't support this property or method and highlighted is

Please Login or Register  to view this content.

For Norie:
Compile error: Next without For and highlighted

Please Login or Register  to view this content.

[judgeh59]

Norie - looks like you left out the END IF....

Please Login or Register  to view this content.

[ciresuark]

You got it! I added it in and it works wonderfully. Thank you all for your help!

[judgeh59]

Great job Norie....I never played with the Controls object....thanks....