Combobox unique dropdown from list with duplicate values error

Hi and thanks for looking. I have uploaded my workbook to make it easier to demonstrate my issue.

I have placed a combobox in the "summary" tab. I would like to be able to select unique values from column B of the "Engage 2014" tab. (the range in Col B B will grow each week)

I have place the code below in a module but.... to no avail!! could someone offer any advice? Many thanks

Please Login or Register  to view this content.

Accidental duplicate.

The only combobox in the workbook is ComboBox1 on the sheet 'Summary'.

If that's the one you want to populate with unique values change the code to refer to that sheet.

Also clear the ListFillRange of the combobox.

Please Login or Register  to view this content.

You might also want to put this in Summary's module.

Please Login or Register  to view this content.

Hi and thanks for looking - I found this code on the tinternet and tried to adapt it... I have no user form, just a combobox in the summary tab.

The range I would like to select the unique values from is called combolist but this will grow each week..

Does that help? cheers

Hi Norie - thanks for looking, I'll have a bash now and report back. Thanks again for your time.

This will take care of expanding data.

Please Login or Register  to view this content.

Hey Guys - great stuff, its working fine now. Many many thanks for your help it's really much appreciated.

Norie - thanks for the second bit which takes care of expanding date - just tried it out, perfect.