Retrieving text being typed and cursor position using VBA or automation, how?

K

Kallepalle

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
 
D

Dave Peterson

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???
 
C

Chip Pearson

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
 
Top