printing userform listbox

[cassiopea]

I have a userform with frame and a listbox in a frame. Listbox is higher than a frame so a frame has a scroll bar.
How can I print the whole listbox with all items?

The code UserForm.PrintForm will print just the 'visible' part of listbox, but not the rest of it which is hidden in the frame

[Andy Pope]

As you say the userform print method only prints what is visible on the userform.

So to use that method you will need to make the form/listbox bigger.

The normal approach is to use a worksheet, which you populate with information, for printing.

[cassiopea]

unfortunatelly, my boss likes the listbox and dislikes the workshhet.

I can't make listbox ie. frame bigger, because listbox is very high (more than 2000) and it doesn't look nice, and it also doesn't fit on the screen, so again, I would get only what is seen on the screen, but not everything "below" the screen

Is there some way, perhaps with listindex or something, so I can determine how many items are there and print them?

[Andy Pope]

unfortunatelly, my boss likes the listbox and dislikes the workshhet.

It's printed output you are creating, how would your boss know or care if a worksheet was used as way of making the printout readable?

So you have a listbox with +2000 items. Which of those items should be in the print out?

the properties
ListCount - how many items in list
ListIndex - currently selected item, zero based and single selection
TopIndex - item number of first visible row

[royUK]

One huge Listbox with 2000 lines, the list would span many sheets any way

[cassiopea]

All items in listbox should be printed.

[royUK]

The only sensible way is to print the list from which the ListBox is populated

[cassiopea]

I have another problem.

I have one listbox with items, and with a command button I transfer selected items to another listbox.
How can I now selected items from second listbox transfer to worksheet?

[Andy Pope]

Start another thread.
Explain the problem and post example file, as your current question does not make much sense to those who do not know your project inside out.

[cassiopea]

I have a userform with a listbox and several command buttons and labels.

Is it possible to print just the listbox?

If I use UserForm.PrintForm it prints all the 'objects' on the userform. Is it possibe to print just selected 'objects' on that userform, for example just the listbox?

[royUK]

I have a userform with a listbox and several command buttons and labels.

Is it possible to print just the listbox?

If I use UserForm.PrintForm it prints all the 'objects' on the userform. Is it possibe to print just selected 'objects' on that userform, for example just the listbox?

Isn't this what we just answered above?