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

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