VBA code to print Userform to specific Printer

Hi, Looking for a bit of help.

I am wanting to create a code to print a series of labels via a userform called 'Labels'. On the attached trial file this is carried out by pressing the "Extra org labels' button to the lower right of the 'menu' form. At present my system works fine if I manually change the default printer to the one I want to use each time (i.e. printer = 'Ernie on Ne02'). However, I was hoping someone could suggest a code that would automatically change the printer to 'Ernie on Ne02', then print the userform created labels and then reset the default printer. I've tried a range of options posted on this forum and other but each time they print the worksheet rather than the userform generated labels.

Thanks for your help
Ross

Wouldn't something like this do the job ?

Please Login or Register  to view this content.