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