Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill cbox unique value
In user form have cbox1 and cbox2.
2 Prob: prob 1) in initialize userform Fill with unique value cbox2 range L3:L....and fill with unique value cbox1 range d3:d.... prob 2) in change event cbox2 If i select 4500 list in cbox1 only the value refered 4500 (in this case only 2 unique value 146900090000 and 299900000000), if i select in cbox2 4580 list in cbox1 only the refered value for 4580... attached sheet he http://www.mytempdir.com/1144880 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill cbox unique value
You can start here at John Walkenbach's site:
http://www.j-walk.com/ss/excel/tips/tip47.htm Then it would just be a matter of modification and using the appropriate events. -- Regards, Tom Ogilvy "sal21" wrote in message ups.com... In user form have cbox1 and cbox2. 2 Prob: prob 1) in initialize userform Fill with unique value cbox2 range L3:L....and fill with unique value cbox1 range d3:d.... prob 2) in change event cbox2 If i select 4500 list in cbox1 only the value refered 4500 (in this case only 2 unique value 146900090000 and 299900000000), if i select in cbox2 4580 list in cbox1 only the refered value for 4580... attached sheet he http://www.mytempdir.com/1144880 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
How to pick out unique components in a list with unique and common | Excel Discussion (Misc queries) | |||
Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
I have many cbox value to chg would like to use integer to do | Excel Programming | |||
Formulas for...1. Counting unique cells 2. Display unique contents | Excel Programming |