You can but you need to program it. See
http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NANCY" wrote in message
...
We are creating form in excel and have 2 drop down menus - can you link
options from the first drop down box to the second - Example

Box #1 - has listing of deparment numbers

Box #2 - has listing of account numbers

We would like the outcome to be: Once the department is selected and you
are selecting a account number - we would like "Only" the account numbers
that pertain to that department as the option