| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox displays duplicates - please help
Please Help!
In my ComboBox property I have a ListFillRange 'Input data'!C1 - C200 Column 'C' has duplicate names. I can't edit or change column 'C' How do I write code so that it will not display duplicates when selecting the comboBox. I think a function like this but not sure how to write it... in Properties for the combobox. I would set the following to pass back name in column 'C' but filter out duplicates. ListFillRange = NoDuplicates("C1:C200") Thank you for your help -- Jeff |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox displays duplicates - please help
John Walkenbach shows how to use a collection to get a unique list. He also
shows how that list can be sorted (you may want to do that): http://j-walk.com/ss/excel/tips/tip47.htm Jeff wrote: Please Help! In my ComboBox property I have a ListFillRange 'Input data'!C1 - C200 Column 'C' has duplicate names. I can't edit or change column 'C' How do I write code so that it will not display duplicates when selecting the comboBox. I think a function like this but not sure how to write it... in Properties for the combobox. I would set the following to pass back name in column 'C' but filter out duplicates. ListFillRange = NoDuplicates("C1:C200") Thank you for your help -- Jeff -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ComboBox displays duplicates - please help
Thank you, it is very helpful. :-)
-- Jeff "Dave Peterson" wrote: John Walkenbach shows how to use a collection to get a unique list. He also shows how that list can be sorted (you may want to do that): http://j-walk.com/ss/excel/tips/tip47.htm Jeff wrote: Please Help! In my ComboBox property I have a ListFillRange 'Input data'!C1 - C200 Column 'C' has duplicate names. I can't edit or change column 'C' How do I write code so that it will not display duplicates when selecting the comboBox. I think a function like this but not sure how to write it... in Properties for the combobox. I would set the following to pass back name in column 'C' but filter out duplicates. ListFillRange = NoDuplicates("C1:C200") Thank you for your help -- Jeff -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserted comment not displays in the cell it displays on top row | Excel Worksheet Functions | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| duplicates in validation list combobox | Excel Discussion (Misc queries) | |||
| Combobox items determined by the selection in another combobox | Excel Programming | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Hybrid Mode
