Noob question from a first-time poster:
Okay, so basically I have a macro that is doing a bunch of stuff, but I'll just give you the pertinent information. I have a UserForm with a bunch of checkboxes, and I basically want it to spit out a string with a list of all of the checkbox names of all the checked boxes. And then I'll use that string elsewhere in a Range(...).Select command.
This is as far as I've gotten...
So it's checking each box and returning the Name as the variable "Selected Columns", but how can I get that to list it out so that each of those names goes into another section like this...![]()
Please Login or Register to view this content.
...where C1, D1, etc. will be replaced with the names of each checkbox.![]()
Please Login or Register to view this content.
Let me know if that makes sense, or if I need to add more information. Thanks! (Excel 2010)
Bookmarks