LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
check that active cell is within a range alstubna Excel Programming 2 February 16th 08 09:37 PM
run macro although blinking cursor is active in an active cell bartman1980 Excel Programming 1 December 20th 07 11:29 AM
If active cell value is 1, run this macro Darin Kramer Excel Programming 1 July 21st 06 08:31 PM
Macro to paste in the active cell the contents of a cell from another file?? LarryB Excel Programming 3 June 12th 06 06:37 PM
check active cell column KimR.Hammel[_2_] Excel Programming 2 August 10th 05 09:35 PM


All times are GMT +1. The time now is 11:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"