I've been using userforms to print labels, works great! I call a userform by double clicking a row of data in a certain sheet and the userform is filled with that data, then the userform is printed from a command button on the userform using this method: 
Please Login or Register  to view this content.
Please Login or Register  to view this content.
That method is the only one I've found that doesn't involve API coding and that doesn't change the default printer of windows. That's normally not an issue just printing to the selected printer, however with this new userform I need to adjust printer settings prior to printing. I just discovered that changing the printer settings from the print dialog that opens doesn't affect the printed userform. However it changes the printer settings for the excel file. So the userform still prints to the selected printer but not with the selected settings, i.e. different printer tray. Is there a way to do that by adding something into the code above?

Thanks!