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

  • Thread starter Thread starter Kallepalle
  • Start date Start date
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
 
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???
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top