Print ListBox

Hello,

I am playing around with some code that I found that prints a listbox to another sheet and then prints out. What I need to do is print listbox items that are shown from sheet1. Then transfer listbox items to Sheet3, printout and then delete what was put in sheet3. This code will work to print contents of column A but I need to print A thru F which is what is shown in the listbox.

Could someone assist me with how to do this? Any help is greatly appreciated. Here is the code I have been using:

Please Login or Register  to view this content.

If all you want to do is just print range A through F, use;

Please Login or Register  to view this content.

Please note it sounds like you want to print sheet 3, but your above code references sheet 1.

Hi Medpack

Thanks for the help... I was trying to remember what the code was. I was putting

Please Login or Register  to view this content.

The other part of this is, I don't really want to print anything to sheet3. I just want to directly print what is in the listbox. Is that possible?

Hi Medpack,

I am confused for sure on this... My listbox is populated from Sheet1 and is A thru F. I assume the code needs to transfer the listbox contents to another sheet? In my case Sheet3. But it is only printing column A to sheet 3 and prints the contents of sheet1 in the printout.

Anyone have any ideas on this ? I'm not sure where I am going wrong with the code. Thanks

I think we should start over here; exactly what are you trying to accomplish? I'm confused why you need to print data to sheet 3.