Printing based on UserForm Selections

[Hornet2433]

I am a newbie programmer with VBA, I am trying to allow a user to print certain sheets from a workbook, depending on which sheets they want. I have created a UserForm with all of the different worksheets as options to click, and finally have a command button that would ideally initialize the print spooling of the corresponding sheets. I have attempted to create a code or to but to no avail, does anyone have any code suggestions for the 'print' button that will execute the printing of the appropriate sheets? Thanks in advance.

 

[shaggi]

worksheets("Sheet1&quot.Printout, as you get to the fullstop VB will give you the options you can use with the "Object".

Adrian

 

[Hornet2433]

??? Sorry this didnt work...

 

[shaggi]

sorry,
think you may have to put the focus on the worksheet first, try:

Application.ScreenUpdating = False
UserForm1.Hide
Worksheets("Sheet1&quot.Activate
Worksheets("Sheet1&quot.PrintOut
UserForm1.Show
Application.ScreenUpdating = True

works ok for me, let me know how you go

Adrian