See the Dependent Lists section of Debra Dalgleish's website:

http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"kbjin" wrote:

Hi does anybody know how can I create two combo boxes that can be used
a filter to pick up address divided into country?

e.g. I want to pick all the address in the uk (in the first combo box),
it will prepare for the second combo box.
wehn i come to the second combo box, all the address within the uk can
be listed there.
can anybody help?
thanks. sam