loop through selection in list box

[Code Flunkie]

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

Please Login or Register  to view this content.

Thanks,

Chris

[Norie]

Chris

Do you just want to loop through the listbox?

Please Login or Register  to view this content.

[Tinbendr]

Please Login or Register  to view this content.

[Code Flunkie]

No, I want to loop through the columns they refer to and for each column selected do something

[Norie]

If you mean you want to loop through the selected items in the listbox see Tinbendr's code.

[Code Flunkie]

I don't think I was very clear, the listbox is composed of the values of the first row of a range of columns ie

"cb1" value
"cc1" value
"cd1" value
etc...

what i want to do is if say cb1 and cd1 is selected I want to take those full columns and loop through for example

do stuff with cb1
then do stuff with cd1
etc...

hopefully that clears it up.

[Norie]

The thing is, we don't know what 'stuff' it is you want to do so can only really suggest the basic code for the loop.

Below I've added to Tinbendr's code to set a range, rngCol, for the selected column(s) as you loop.

Please Login or Register  to view this content.

[Code Flunkie]

I know how to do the other stuff, it was just going from the selection to the actual columns I was unclear of. I think this should work.

thanks for all the help.

Chris