VBA check box selections to dynamically create a formatted table

[mansions_and_benzs]

Hello! I'm not great with VBA, and most things I've learned through other posts .

Basically, I am trying to create a table on a new sheet based on check box selections from another sheet. There are lots of selection options. First there's a list of topics that I have used ActiveX check boxes for which expose sub-topics, also with associated check boxes (I used form control for these).

The user first selects the ActiveX topic check boxes to show the sub-topic check boxes -- there can be anywhere from 1 sub-topic to 10 sub-topics under each of these. They then select the applicable sub-topics (not necessarily all under a topic and not in any particular order). I then added a button at the end to create the formatted table on this new sheet - which runs a series of macros.

In the new sheet table, I have some table headers already built in. Then what should be listed is:


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]topic 2 (first selected topic)[/TD]
[TD](topic 2) sub-topic 2 (first selected sub-topic under topic 2)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD](topic 2) sub-topic 5 (second selected sub-topic under topic 2)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD](topic 2) sub-topic 10 (third selected sub-topic under topic 2)[/TD]
[/TR]
[TR]
[TD]topic 7 (second selected topic)[/TD]
[TD](topic 7) sub-topic 3 (first selected sub-topic under topic 7)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD](topic 7) sub-topic 4 (second selected sub-topic under topic 7)[/TD]
[/TR]
[TR]
[TD]etc.[/TD]
[TD]etc.[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
The hard part for me is dealing with the total non-sequential nature (the table is totally dynamic off of selections which do not need to be in any particular order).

Any help would be greatly appreciated!