I have a multi select list box that lists the cell contents of row 1 from a range of CB1 to the end of the sheet. and puts them into a single column list. what i'm trying to do is take the items that are selected and produce 6 pdfs of each selection (1 for each price level) I know how to produce the pdfs and format the data. I was thinking of using a template worksheet and copy the columns over and do 1 sheet at a time. but i'm unsure if this is the most efficient method because it could be up to 150 pdf's. also I don't know how to take the items selected in the list box and transfer it to the macro. any advice would be great.
here is the code for the listbox
Thanks,Please Login or Register to view this content.
Chris
Bookmarks