available printers in a listbox

  • Thread starter Thread starter Corey
  • Start date Start date
C

Corey

Is there a simple way to have a form show all available printers in a listbox, and a user to simply
select one to print to it ?
 
I believe I used
Application.Dialogs(xlDialogPrinterSetup).Show
in a previous project.
 
just use something like this, it's much easier

dim bOK as string

bOK = Application.Dialogs(xlDialogPrinterSetup).Show 'choose the printer
If bOK = False Then exit sub
 
perfect thanks



"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
just use something like this, it's much easier

dim bOK as string

bOK = Application.Dialogs(xlDialogPrinterSetup).Show 'choose the printer
If bOK = False Then exit sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Cannot select items in listbox 1
Listbox to display ALL Available Printers to User on a Userfrom 2
Access Using DAO.Database VBA code to populate a listbox from another listbox selection 1
using variables in listbox 9
Getting printers list to put in userform 1
ListBox Remove Certain Text 6
How to set focus on an ActiveX ListBox 7
Adding items from Listbox to empty textbox 2

Back
Top