View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leo Heuser[_3_] Leo Heuser[_3_] is offline
external usenet poster
 
Posts: 109
Default Get Cell Value while typing

Hi LamNgo

I don't believe, it's possible.
Excel's Change-event returns, what's in the
cell, *after* the user press tab or enter.

There's no key-down event, when it comes
to entering data in a cell.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"LamNgo" skrev i en meddelelse
om...
Hi groups,

I write a VC++ programme that hooks user actions on Esxcel
application. One user click on a cell, my programme must detect the
location and value of that cell. Everything is ok for mouse action.

For typing action, I want to get value of the editing cell just before
user press tab or enter. But what I receive is the value of cell
before user edit it.

Is there any solution for this problem?

Thanks,
LamNgo