| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If cell entry does not match options = error
Cells A1 to A5 each have a word. The entry needed in A6 must be one of the
words in A1 to A5 exactly. I am wondering if there is a way to prevent the entry of anything but one of the 5 options otherwise you would get an error or blank entry or some other way to handle this? -- Thanks Everyone Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If cell entry does not match options = error
As a user, I think Data|Validation (xl2003 menus) would work nicely.
Debra Dalgleish explains he http://contextures.com/xlDataVal01.html ZIPPOMA NEEDS HELP wrote: Cells A1 to A5 each have a word. The entry needed in A6 must be one of the words in A1 to A5 exactly. I am wondering if there is a way to prevent the entry of anything but one of the 5 options otherwise you would get an error or blank entry or some other way to handle this? -- Thanks Everyone Mike -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| entry must match value in range | Excel Worksheet Functions | |||
| paste options - set default to match destination formatting | Excel Discussion (Misc queries) | |||
| HDI change paste options default to "Match Destination Formatting | Setting up and Configuration of Excel | |||
| options error | Excel Discussion (Misc queries) | |||
Linear Mode
