Hi Guys,

I'm having some issues trying to set up code to copy the whole list from the second combo box on a worksheet to a cell in that worksheet. This is just a small part of a larger model, so I'm not really able to load the file up for you to see.

The problem is the second Combo Box (cbR2Brands) list chances as it is driven from the users selection in the first Combo Box (cbR2Supplier). I did try to filter the oringal source list that these combo boxes read from but as there are a number of tables within that spreadsheet excel crashed each time when I tried run the code to filter them.

So I found some code on the WEB and tried to modify it to suite but I'm getting no were.

Please Login or Register  to view this content.
I'm still very new to all this and I happy if there is another point of view to achive this result.

Thanks in advance.

Regards
BJ5352