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

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

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