I am looking to do 2 things:

1) Capture data typed into the cell as it's typed before Enter is pushed
2) Create a box under the cell(like when you start to type in a formula and
it provides the formulas that match what you type)

Can someone point me in the right direction on what I should be looking for
and I can figure out the code from there.

Thanks!

Macros do not run when you're in edit mode. You's need to position a
textbox over the cell and have the user type in that.

Maybe something here might work for you:
http://www.contextures.com/xlDataVal10.html

Tim

"jayklmno" wrote in message
...
I am looking to do 2 things:

1) Capture data typed into the cell as it's typed before Enter is pushed
2) Create a box under the cell(like when you start to type in a formula
and
it provides the formulas that match what you type)

Can someone point me in the right direction on what I should be looking
for
and I can figure out the code from there.

Thanks!