Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cursor position MarkT Excel Discussion (Misc queries) 5 February 7th 07 01:25 PM
Cursor position saziz Excel Discussion (Misc queries) 2 August 9th 05 08:19 PM
Cursor position? Marc Excel Discussion (Misc queries) 1 March 27th 05 07:09 PM
How do I get cursor position and text being typed? Kallepalle Excel Programming 2 February 19th 04 05:49 PM
cursor position NTL Excel Programming 1 January 18th 04 08:23 PM


All times are GMT +1. The time now is 10:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"