Populating the combo from worksheets
 

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

Populating the combo from worksheets
 

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