Printing

  • Thread starter Thread starter Libby
  • Start date Start date
L

Libby

Hi

I have a macro which displays a userform and executes some
code. On the userform is a listbox which has things added
to it as the code is executed. Is there any way I can have
a print button on the userform which will print out the
contents of the listbox once the code has finished?


Many thanks in advance
Libby
 
I think you have to do something like put the listbox contents in a range
and then print the range.

--
Jim Rech
Excel MVP
| Hi
|
| I have a macro which displays a userform and executes some
| code. On the userform is a listbox which has things added
| to it as the code is executed. Is there any way I can have
| a print button on the userform which will print out the
| contents of the listbox once the code has finished?
|
|
| Many thanks in advance
| Libby
 
You must log in or register to reply here.

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

Userform to Select what worksheets to print 1
Command button - check listbox contents before activating? 3
Command button - compare computer name with a pass code 3
Print Preview Freezes 1
Common Function for getting userform information 6
Set Cell value form ListBox. 4
inconsistent dir() behavior 1
Userform within a userform ... 7

Back
Top