Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Unique Values in a Combobox
I have combobox1 which references Values in Column A.
There may be multiple values with the same name in this Column. For example if the value "Todd" was in the Column in 4 different locations, the combobox will display the value "Todd" 4 times in the order in which they occur in the Column. I do not want this. My code is below ComboBox1.RowSource = "OFFSET(" & Worksheets(1).Name & "! A1,,,COUNTA(" & Worksheets(8).Name & "!A:A))" How do I modify or what do I add to this code to make it list only unique values? Thank you Todd Huttensitne |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Unique Values in a Combobox
Todd,
John Walkenbach has a tip for this at: http://j-walk.com/ss/excel/tips/tip47.htm hth, Doug "Todd Htuttenstine" wrote in message ... I have combobox1 which references Values in Column A. There may be multiple values with the same name in this Column. For example if the value "Todd" was in the Column in 4 different locations, the combobox will display the value "Todd" 4 times in the order in which they occur in the Column. I do not want this. My code is below ComboBox1.RowSource = "OFFSET(" & Worksheets(1).Name & "! A1,,,COUNTA(" & Worksheets(8).Name & "!A:A))" How do I modify or what do I add to this code to make it list only unique values? Thank you Todd Huttensitne |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Unique Values in a Combobox
Thank you. Will take a look at that when I get home.
-----Original Message----- Todd, John Walkenbach has a tip for this at: http://j-walk.com/ss/excel/tips/tip47.htm hth, Doug "Todd Htuttenstine" wrote in message ... I have combobox1 which references Values in Column A. There may be multiple values with the same name in this Column. For example if the value "Todd" was in the Column in 4 different locations, the combobox will display the value "Todd" 4 times in the order in which they occur in the Column. I do not want this. My code is below ComboBox1.RowSource = "OFFSET(" & Worksheets(1).Name & "! A1,,,COUNTA(" & Worksheets(8).Name & "!A:A))" How do I modify or what do I add to this code to make it list only unique values? Thank you Todd Huttensitne . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique Values, not Unique Records | Excel Discussion (Misc queries) | |||
Using Unique Values in as a combobox value list | Excel Discussion (Misc queries) | |||
Displaying unique entries from a filtered list | Excel Worksheet Functions | |||
Displaying only unique values, PLEASE HELP | Excel Discussion (Misc queries) | |||
Displaying all the states in a VBA combobox | Excel Programming |