Print out listbox data code

[herukuncahyono]

Hi,
I have no idea how to print all value appears on the listbox .I tried some code but failed.

Thanks in advance
herukuncahyono

[tony h]

I don't really understand what you are trying to do.

[Palmetto]

You would need to write the list box values to a range of cells and print from the worksheet.

However, since you are using Case Statements to fill the list box, why not just set the print area to that range of cells and print as needed? You could, if necessary, copy the cells to another worksheet.

This is, by far the easiest way to go about it as the code would be very minimal.

[herukuncahyono]

hi Palmetto,
thanks for the reply ,I almost get a solution on the internet(code to print listbox) but the problem is, there are only 1 column was printed ( I attach an example ) I want all data in listbox is printed,
thanks in advance

herukuncahyono

[Palmetto]

In order to print each column of the list box you must reference each column, like so:

Please Login or Register  to view this content.

[herukuncahyono]

hi Palmetto,
great fit with my expectations,my problem solved

thank you I really appreciate it

herukuncahyono