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