Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Cell Value while typing
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Cell Value while typing
Hi
If I understood you this is probably not possible. Maybe you could explain what you're trying to achieve with this information. There may be a workaround -- Regards Frank Kabel Frankfurt, Germany LamNgo wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Cell Value while typing
Hi, Thanks for your respones. I want to explain a litle more about my problem so that you could help me more. My programme hook into the system queue to capture user action. So that the messages system send to Excel application will be examined by our programme before Excel app receive them. Once I detect a WM_KEYDOWN with wParam is VK_RETURN or VK_TAB, I would like to get the information in the cell which is being edited by user. This mean the information will be get before Excel receive the Tab key. I used GetActiveCell() method and got it, but the value of cell is before user edit it, not at the time user press TAB. Thanks, Lam *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Cell Value while typing
If you are capturing the keystrokes, you have what the user is entering.
-- Regards, Tom Ogilvy "Lam" wrote in message ... Hi, Thanks for your respones. I want to explain a litle more about my problem so that you could help me more. My programme hook into the system queue to capture user action. So that the messages system send to Excel application will be examined by our programme before Excel app receive them. Once I detect a WM_KEYDOWN with wParam is VK_RETURN or VK_TAB, I would like to get the information in the cell which is being edited by user. This mean the information will be get before Excel receive the Tab key. I used GetActiveCell() method and got it, but the value of cell is before user edit it, not at the time user press TAB. Thanks, Lam *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Cell Value while typing
In some case, the cell value is different from what you're typed in, for
example: autocomplete, fomular... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Typing more than 1 line in a cell | Excel Discussion (Misc queries) | |||
Typing in a cell | Excel Discussion (Misc queries) | |||
why won't my typing in a cell show up????????? | Excel Discussion (Misc queries) | |||
Typing in cell cuts off. | Excel Discussion (Misc queries) | |||
how do i go to a cell by just typing a letter | Excel Discussion (Misc queries) |