Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving text being typed and cursor position using VBA or automation, how?
Hi,
How do I retrieve the current text being entered in a cell and the cursor position. NB: I am /not/ looking for the contents of the current cell - I am looking for the text in the edit box where contents of a cell are displayed for editing and/or input. The reason I need this is that I am developing a typing aid for dyslexics, and would like to support Excel. Apparently Excel does not use the standard edit controls for this, as the usual windows messages for edit/richedit controls do not seem to work. Sincerely, Anders S. Johansen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving text being typed and cursor position using VBA orautomation, how?
I don't think you can do much while excel is still in edit mode.
Maybe you could toss up a small userform and control over the input??? Kallepalle wrote: Hi, How do I retrieve the current text being entered in a cell and the cursor position. NB: I am /not/ looking for the contents of the current cell - I am looking for the text in the edit box where contents of a cell are displayed for editing and/or input. The reason I need this is that I am developing a typing aid for dyslexics, and would like to support Excel. Apparently Excel does not use the standard edit controls for this, as the usual windows messages for edit/richedit controls do not seem to work. Sincerely, Anders S. Johansen -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieving text being typed and cursor position using VBA or automation, how?
VBA can't execute code while Excel is in edit mode, so there is
no way to do this. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Kallepalle" wrote in message om... Hi, How do I retrieve the current text being entered in a cell and the cursor position. NB: I am /not/ looking for the contents of the current cell - I am looking for the text in the edit box where contents of a cell are displayed for editing and/or input. The reason I need this is that I am developing a typing aid for dyslexics, and would like to support Excel. Apparently Excel does not use the standard edit controls for this, as the usual windows messages for edit/richedit controls do not seem to work. Sincerely, Anders S. Johansen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cursor position | Excel Discussion (Misc queries) | |||
Cursor position | Excel Discussion (Misc queries) | |||
Cursor position? | Excel Discussion (Misc queries) | |||
How do I get cursor position and text being typed? | Excel Programming | |||
cursor position | Excel Programming |