| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I force values in a cell in excel?
Hi Peo,
I refer to my list by: =Category "Peo Sjoblom" wrote: How is your list referred to =$A$1:$A$10 =MyList or something else, if you type in the list values directly you don't need the equal sign but you need to use comma as delimiter -- Regards, Peo Sjoblom Portland, Oregon "Phyllis" wrote in message ... Yes, this is checked off. Phyllis "Kevin B" wrote: I the "Show Error alert after invalid data is entered" checked off? If it isn't, no error message will appear. -- Kevin Backmann "Phyllis" wrote: I have a simple list of categories that I have put into a drop down list. I have checked off the Error Alert box under validation and entered a warning message. I want to force the user to either choose a category from the drop down list or type it exactly as it appears in the drop down. From all I've read it seems that all I have to do is check that Error Alert box, but it's not working. I have tested it and when I enter something that is not part of the list it just lets me continue. No warning message or anything. What am I doing wrong? Phyllis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to make conditional sounds based on cell values in Excel | New Users to Excel | |||
| Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
| Can you reference cell values in Headers and Footers in Excel 200. | Excel Discussion (Misc queries) | |||
Hybrid Mode
