Sorry but what you want to do just does not exist. There is no key press
event such as you would find in a Textbox. The easiest way around it might be
to add a text box depending on what you goal is...
--
HTH...

Jim Thomlinson


"abhigreen" wrote:

>
> Hi,
> I want to know if I can capture a keypress event in a cell in some
> way.
>
> My problem is this.
> A cell say $F$1 has date value "12/12/9999". Through VBA, I have made
> the font for this white ("12/12/9999" is default NULL and hence should
> not be visible).
>
> However, when I do the following on $F$1
> a. I press CTRL + ; (which gives current date) or
> b. Press F2 and type a new date manually,
> I want the text in $F$1 to have a black font.
> I would like to have this before I move on to any other cell (by
> pressing tab) or clicking somewhere else. This precludes using
> Worksheet_SelectionChange or Worksheet_change event
>
> Please let me know how I can address this problem
>
> Thanks in advance
> 'Abhi' (http://abhishrek.blogspot.com)
>
>
> --
> abhigreen
> ------------------------------------------------------------------------
> abhigreen's Profile: http://www.excelforum.com/member.php...o&userid=32265
> View this thread: http://www.excelforum.com/showthread...hreadid=520179
>
>