Combo Box list of unique values in range

**Jason_2112** · 11-09-2010, 05:32 PM

Hello,

I've attached a workbook with the basics of what I need to do. I'm using a User Form and would like to input data on the form using values that are already existing in a range. The workbook is pretty self-explanatory.

Thanks,
Jason

**jaslake** · 11-09-2010, 05:54 PM

Hi Jason

I've added a couple of Dynamic Named Ranges to your workbook. This should do as you require.

Let me know of issues.

John

**Jason_2112** · 11-10-2010, 12:50 PM

Thanks for the help, John. That does mostly what I need, however, I would like to have only unique values show up in the combo box. I found a way to make a dynamic list of unique values at this site: http://www.eggheadcafe.com/software/...ct-values.aspx - all the way at the bottom of the page. This method takes a long time to compute every time I add data to the sheet using the user form.

Any other suggestions?

Thanks,

Jason

**jaslake** · 11-10-2010, 12:55 PM

Hi Jason

Sorry, I missed this

I would like to have only unique values show up in the combo box

That's quite easily done. I'll post back this afternoon.

John

**jaslake** · 11-10-2010, 01:17 PM

Hi Jason

Try the attached. Let me know of issues.

John

**Jason_2112** · 11-10-2010, 01:44 PM

Is there a way to make the list on Sheet2 a dynamic list so that if a new unique value is added to the data on Sheet1, the extracted unique values will also update?

**jaslake** · 11-10-2010, 01:50 PM

Hi Jason

The procedure as written does that each time the "Show UserForm1" button is clicked.

If you add a unique value in Columns A or B, it will be added to the Dynamic Ranges on sheet2 on button click.

Is this what you have in mind?

John

**Jason_2112** · 11-10-2010, 02:03 PM

Yes. That's exactly what I wanted it to do. Sorry I hadn't fully tested it out... didn't realize it was part of the code for the user form.

Thanks again for your help!

Jason

**jaslake** · 11-10-2010, 02:10 PM

Hi Jason

Glad to be of help. If this resolves your issue, please mark your thread as solved.

To mark your thread solved do the following:
- Go to your first post on the thread
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

If I've helped, a click on the scales is appreciated.

John