Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique values in combobox2 in excel VBA
Hi all,
I want to add unique values in combobox2 once I select from combobox1. Column A Column B -------- -------- Girls Hair Boys Hair Veg Water Non-Veg Water Once I select Girls in combobox1 (retrieved from column 'A' in excel), it should show unique value of 'Hair' from column 'B' instead of twice in excel. I want to add the unique values in combobox2 from column 'B' in excel where combobox1 text is equal to column 'A'. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique values in combobox2 in excel VBA
Hi all,
I want to add unique values in combobox2 once I select from combobox1. Column A Column B -------- -------- Girls Hair Boys Hair Veg Water Non-Veg Water Once I select Girls in combobox1 (retrieved from column 'A' in excel), it should show unique value of 'Hair' from column 'B' instead of twice in excel. I want to add the unique values in combobox2 from column 'B' in excel where combobox1 text is equal to column 'A'. Why are you using Combobox2? The purpose of a combobox is to provide a list of items, not a unique value. A formula will do what you want... In B2: =IF(OR(A2="Girls",A2="Boys"),"Hair","Water") ...and copy down! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Close DropDown of ComboBox2 & Open ComboBox1 on Error | Excel Programming | |||
excel unique values in column | Excel Programming | |||
How do I get the unique values from a column in excel? | Excel Worksheet Functions | |||
HOW DO I REMOVE UNIQUE VALUES IN EXCEL? | Excel Worksheet Functions | |||
filter unique values Excel | Excel Programming |