"Charlie" wrote:
Supp cell-A1 has a list box with 3 options - America,UK,India.Now if i choose
America from that list then it should show me the cities of America in a list
box in cell no B1..Same way if i choose UK then in cell B1, it should show
the cities of UK .

Try Debra's page at:
http://www.contextures.com/xlDataVal13.html
Data Validation -- Dependent Dropdowns from a Sorted List

Another good source is Bob Phillips':
http://www.xldynamic.com/source/xld.Dropdowns.html
Dynamic Dependent Dropdowns

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---