Printer Selection in VBA
belgo
-
tyranausor Posted messages 3501 Registration date Status Member Last intervention -
tyranausor Posted messages 3501 Registration date Status Member Last intervention -
Hello,
I have a little problem selecting a printer in VBA.
I want to print a UserForm with the printer of my choice.
I can open the dialog box, but when I select the printer, it only changes the Excel printer and not the Microsoft Visual Basic printer (Developer tab/Visual Basic).
However, it is on this printer that my userform gets printed.
I also tried changing the default printer when opening the userform, and the same result occurs: the Excel printer changes fine, but not the one for Microsoft Visual Basic.
Thank you for your help.
I have a little problem selecting a printer in VBA.
I want to print a UserForm with the printer of my choice.
I can open the dialog box, but when I select the printer, it only changes the Excel printer and not the Microsoft Visual Basic printer (Developer tab/Visual Basic).
However, it is on this printer that my userform gets printed.
I also tried changing the default printer when opening the userform, and the same result occurs: the Excel printer changes fine, but not the one for Microsoft Visual Basic.
Thank you for your help.