Siva,

Take a look at http://xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Siva" wrote in message
...
Hi,
I have two work sheets one filled up with country information (countryid
and
name) and other worksheet filled with state information (stateid,statename
and countryid). I have a form which has 2 combo boxes. In one combo I need
to
display all the country names and on selecting a country from the country
combo, I need to display the matching states in the second combo using
the
information from the worksheets. Kindly help me out in doing this.

Thanks and Regards,
Siva