ComboBox in USERFORM used to change which sheet output goes

In the attached file, I'm using a userform to fill 6 cells and print the sheet.

I have some hidden sheets in the workbook, which can be choosen (only by name) from the combobox in my userform.

-How can I make it so that if I choose a different sheet in the combobox, the userform applies to that sheet?

(PS: I know its the same cell in my module for each sheet - i'll be aligning the cell different on each sheet, so the sheets will have a different location for the print.)

EDIT: I for some reason can't attach the sheet directly?

http://www.excelforum.com/attachment...1&d=1459969643

maybe a select case statement would work well in this case?

Please Login or Register  to view this content.