Filling a combo box from the spreadsheet

Another, what I presume, simple request. I have a large dataset and I wish to create a combo box from one of the columns in order to create reports. Due to the sensitive information I'm working on, I have posted up a very simple dummy data file representing the names I wish to have in the combo box. The data set will have multiple lines and I want to avoid putting multiples of the name into the combobox. So I need a code that will loop through the column and perhaps storing them into an array that fills the combobox...

I've had a go on my proper dataset but I haven't got anywhere... Any help would be greatly appreciated.

Rob

Originally Posted by rob0r

Another, what I presume, simple request. I have a large dataset and I wish to create a combo box from one of the columns in order to create reports. Due to the sensitive information I'm working on, I have posted up a very simple dummy data file representing the names I wish to have in the combo box. The data set will have multiple lines and I want to avoid putting multiples of the name into the combobox. So I need a code that will loop through the column and perhaps storing them into an array that fills the combobox...

I've had a go on my proper dataset but I haven't got anywhere... Any help would be greatly appreciated.

Rob

Use a new collection. Since a collection can't have duplicates, there will be an error. To avoid this behaviour, we will use on error resume next and reset this to on error goto 0 at the end of the coding.

Charlize

There are various ways to do this. Here is one:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Charlize

Thanks for that, just about managed to get it sorted.