Using Excel 2007 I created a drop down list with a different tab as the
source. The error alert box is checked but when I enter something other than
what is on the drop down list it allows it and does not give me an error
message. Is there a work around or is this feature not available in 2007?

Thanks.

During my research I have discovered the answer to my question. According to
Microsoft you should not be able to create a name list using letters that
correspond to column headings (I, F, DL DP, etc.). Excel uses those
identifiers for it's own use. I apparently violated that procedure and
created a name list using single and double letters. I did not receive any
error messages. The drop down list I created worked with out an error
message when other than a number on the list was entered. I renamed my drop
down list and also discovered that if there are any blank spaces in the list
Excel will not give you an error message if other data is entered. This only
seems to work when using a name list of data that is not in the current
spreadsheet.

Does Microsoft give out rewards for discovering flaws in their software (He
said tongue in cheek)?

"travelinman" wrote:

Using Excel 2007 I created a drop down list with a different tab as the
source. The error alert box is checked but when I enter something other than
what is on the drop down list it allows it and does not give me an error
message. Is there a work around or is this feature not available in 2007?

Thanks.