Sounds like you are after a WorkSheet_Change event for the first question?
This will fire after data was entered but can tell you what was entered.

For the second question, depending what you want to show, you may be able to
use a Data Validation input message or a popup menu. But as far as I know,
you would not be able to get it to change as you type. A
Worksheet_SelectionChange event could be used to show a message when you
select a cell or a WorkSheet_Change event could be used to show a message
after you enter data.

HTH

"jayklmno" wrote:

I need to do 2 things...
1) Capture data input into a cell prior to hitting Enter.
2) Create a box under the cursor (like when you start typing a formula into
a cell and Excel displays the resulting possibilities).

If you can opoint me in the right direction, I can figure it out from there.

THANKS!