Check out this page from Debra Dalgleish's web site:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"DocBrown" wrote in message
...
I am using a drop-down list for data validation in a column. Can I make
the
drop-down list in another column dependent on the contents of the first
column?

Example:

Col A has a list defined:

Fruit
Vegetable

If the user selects fruit, then in Column B the list is:

Apple
pear

If the user selects Vegetable, then the column B list is:

Peas
Carrots

thanks
John