Hi!

I am using an Excel sheet to capture meeting minutes. During the following meeting I am entering new text in blue while text of last week is black.
Sometimes I am inserting text in a cell with already existing (thus black) text. I would like to write a makro that automatically sets the text colour to blue for the inserted text portion or for the current cursor position prior to inserting.

Here is my strategy:
1. Detect if non empty active cell is being edited (detect double-click or F2).
2. Capture old cell content.
3. After cell is not active anymore (editing completed) compare new cell content to old.
4. Set text colour to blue for the contents which are new.

My question is how can Excel detect that I am inserting text WHILE I am inserting (NOT only AFTER I pressed return or an arrow key).

Any ideas or suggestions for different approach?

Thanks!

Werner