Check Box Captions

[Rich Kniatt]

I have a check box on a user form that triggers a formula that fills in numbers on sheet1 from sheet2 I have this on a template that I use quite a bit. I have been typing the check boxes to match the coloum heading from sheet 2 (changes from book to book) when I create a new book. Is there a way to pull the Column header automaticly its in 2 cells stacked in a column. And I would also like it to place the Name onto sheet1 so when I print I can see the selected options. I'm just learning VBA so be gentle

[Rich Kniatt]

Hate to bump my own up but this is really killing me