| 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 |
| 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) | |||
Threaded Mode
