| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check active cell value without using macro
Is it possible to check the value of a cell without using macros? For
example if somebody enters a "N" into a cell I'd like the cell value to change to "No" automatically. I've investigated conditional formatting and using standard =IF statements (=IF(H2=N,"No", "") but get a circular reference error. Any thoughts? Thank you Simon |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check active cell value without using macro
Tools
Autocorrection change N to No automatically -- met vriendelijke groetjes "simon" schreef in bericht ... Is it possible to check the value of a cell without using macros? For example if somebody enters a "N" into a cell I'd like the cell value to change to "No" automatically. I've investigated conditional formatting and using standard =IF statements (=IF(H2=N,"No", "") but get a circular reference error. Any thoughts? Thank you Simon |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check active cell value without using macro
I think you will need to set it up to change a lower case n to No rather
than the upper case N that you show. Otherwise, typing n into a cell will just enter the n without converting it; and following that up by typing N in the cell under it will not change the N to No either. -- Rick (MVP - Excel) "Frederik" wrote in message ... Tools Autocorrection change N to No automatically -- met vriendelijke groetjes "simon" schreef in bericht ... Is it possible to check the value of a cell without using macros? For example if somebody enters a "N" into a cell I'd like the cell value to change to "No" automatically. I've investigated conditional formatting and using standard =IF statements (=IF(H2=N,"No", "") but get a circular reference error. Any thoughts? Thank you Simon |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check active cell value without using macro
Correct... that is what I was trying to say.
-- Rick (MVP - Excel) "Frederik" wrote in message ... If you do Tools Autocorrection Replace n with No it will work for both the input of n and for N: both will be replaced by No -- met vriendelijke groetjes "Rick Rothstein" schreef in bericht ... I think you will need to set it up to change a lower case n to No rather than the upper case N that you show. Otherwise, typing n into a cell will just enter the n without converting it; and following that up by typing N in the cell under it will not change the N to No either. -- Rick (MVP - Excel) "Frederik" wrote in message ... Tools Autocorrection change N to No automatically -- met vriendelijke groetjes "simon" schreef in bericht ... Is it possible to check the value of a cell without using macros? For example if somebody enters a "N" into a cell I'd like the cell value to change to "No" automatically. I've investigated conditional formatting and using standard =IF statements (=IF(H2=N,"No", "") but get a circular reference error. Any thoughts? Thank you Simon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check that active cell is within a range | Excel Programming | |||
| run macro although blinking cursor is active in an active cell | Excel Programming | |||
| If active cell value is 1, run this macro | Excel Programming | |||
| Macro to paste in the active cell the contents of a cell from another file?? | Excel Programming | |||
| check active cell column | Excel Programming | |||
Linear Mode
