Ray

Debra Dalgleish has instructions for this at

http://www.contextures.on.ca/xlDataVal02.html

Gord Dibben Excel MVP

On Sun, 18 Jan 2004 19:37:55 -0000, "Ray" wrote:

Hello,
Quite new at this
Please bear with me
I know how to create a drop down list and validate it in say cell A5.
How can I automatically create another dropdown list in cell B5 dependent on
value selected in A5.
example:

If alphabet is chosen in A5 then list in B5 is a,b,c....etc
If numbers is chosen in A5 then list in B5 is 1,2,3......etc

Any help would be appreciated

Thanks
Ray