| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to populate a combobox with a list of unique values?
I just populated a combobox through listfillinrange property, just that the
column data source has repeated values... does any body would give me a clue on how to filter just the unique vlaues on the combobox? Thanks in advance and best regards! Gerard! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to populate a combobox with a list of unique values?
I think you'll have to cycle through the cells in that range (and dump the
..listfillrange assignment). John Walkenbach shows a technique at: http://j-walk.com/ss/excel/tips/tip47.htm His example uses a listbox on a userform, but I bet you can change it to work on your listbox on the worksheet. RIOSGER wrote: I just populated a combobox through listfillinrange property, just that the column data source has repeated values... does any body would give me a clue on how to filter just the unique vlaues on the combobox? Thanks in advance and best regards! Gerard! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to populate a combobox with a list of unique values?
Thanks Dave... what I did was to filter the values to get the unique values
before to assign them to the listfillrange property... Thank you... "Dave Peterson" wrote: I think you'll have to cycle through the cells in that range (and dump the ..listfillrange assignment). John Walkenbach shows a technique at: http://j-walk.com/ss/excel/tips/tip47.htm His example uses a listbox on a userform, but I bet you can change it to work on your listbox on the worksheet. RIOSGER wrote: I just populated a combobox through listfillinrange property, just that the column data source has repeated values... does any body would give me a clue on how to filter just the unique vlaues on the combobox? Thanks in advance and best regards! Gerard! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Unique Values in as a combobox value list | Excel Discussion (Misc queries) | |||
| Populate combo box with unique values only | Excel Discussion (Misc queries) | |||
| Populate unique list in combobox | Excel Programming | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Displaying Unique Values in a Combobox | Excel Programming | |||
Linear Mode
