Hi

The link you gave from Debra's site was the wrong one

http://www.contextures.com/xlDataVal02.html
If you follow Debra's instructions from here carefully, it will do just
what you want.

--
Regards

Roger Govier


"New2XL" wrote in message
...
Hi,
I have a requirement which has 2 lists to be populated automatically.
The
2nd list value is based on the 1st list. For eg:

1st List 2nd List
Fruits (Should display list of all fruits
mentioned)
Vegetables (Should display list of all veg mentioned)
Frozen Items (Should display list of all frozen items
mentioned)

If i select fruits, it should display only fruits. I have tried to
other
sites ( http://www.contextures.com/xlFunctions02.html) but there is a
bug in
it. It does not clear the previous values from the second list.

Can someone help, with examples..Appreciated