I have a big problem:

How can I access the text and its selection when a user is editing the
content of a cell?

I can access text easily when cell is only selected. But when a user is
typing sth I cannot access the Cell via ActiveCell anymore. So I cannot
track the text this way.

I even need it more detailed since I would like to gather information
about the text selection a user can make when editing a cell.

Does the Excel Object Model has some Object for this?

Thanks in advance!


--
Buergermeister


------------------------------------------------------------------------
Buergermeister's Profile: http://www.excelforum.com/member.php...o&userid=34150
View this thread: http://www.excelforum.com/showthread...hreadid=539192

Hi
You can access the contents of the cell after the user has finished
typing by using the Worksheet_Change or Worksheet_SelectionChange subs
of the worksheet.
I don't think there is an event which would fire as the user is typing.
This is probably fair enough, as a macro firing every time you hit the
keypad would drive the user nuts, and nobody would speak to you at
coffee.

regards
Paul

Hi,

sorry, not supported in Excel.

There are ways around this, but as far as I know none of them works
reliably. Excel is very likely to crash.

But maybe worksheet_change is what you are looking for. This event
fires whenever worksheet (cell or range) is changed.

Regards,
Ivan

for all practical purposes, Excel macros don't run when a user is editing a
cell.

--
Regards,
Tom Ogilvy


"Buergermeister" wrote:


I have a big problem:

How can I access the text and its selection when a user is editing the
content of a cell?

I can access text easily when cell is only selected. But when a user is
typing sth I cannot access the Cell via ActiveCell anymore. So I cannot
track the text this way.

I even need it more detailed since I would like to gather information
about the text selection a user can make when editing a cell.

Does the Excel Object Model has some Object for this?

Thanks in advance!


--
Buergermeister


------------------------------------------------------------------------
Buergermeister's Profile: http://www.excelforum.com/member.php...o&userid=34150
View this thread: http://www.excelforum.com/showthread...hreadid=539192

well actually i don't want to write a macro but an external application
that needs to know which content is selected to output this on a
special device for visually impaired people.

but if there is no way to access this via the excel object model there
i need to look for another solution.

If someone knows another workaround I would be glad to hear about it
:D

thanks for all the replies.


--
Buergermeister


------------------------------------------------------------------------
Buergermeister's Profile: http://www.excelforum.com/member.php...o&userid=34150
View this thread: http://www.excelforum.com/showthread...hreadid=539192

I think your search would be in the area of subclassing Excel and getting
between Excel and the windows operating system.

--
Regards,
Tom Ogilvy


"Buergermeister" wrote:


well actually i don't want to write a macro but an external application
that needs to know which content is selected to output this on a
special device for visually impaired people.

but if there is no way to access this via the excel object model there
i need to look for another solution.

If someone knows another workaround I would be glad to hear about it
:D

thanks for all the replies.


--
Buergermeister


------------------------------------------------------------------------
Buergermeister's Profile: http://www.excelforum.com/member.php...o&userid=34150
View this thread: http://www.excelforum.com/showthread...hreadid=539192