| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to allow "if then" text?
Looking for a way to allow only three possible entries into a field and using a one letter entry to spell out the full word of that entry, Example: If "P" then (the word) "Pass" is entered. If "F" then "Fail" If "N" then N/A I believe this can only be achieved using a macro, which I have no clue how to write. Thanks! Ken -- Kenshe ------------------------------------------------------------------------ Kenshe's Profile: http://www.excelforum.com/member.php...o&userid=28850 View this thread: http://www.excelforum.com/showthread...hreadid=486081 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Resetting default row height to allow display of wrapped text | New Users to Excel | |||
| Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
| SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
