hi
while typing into a cell, you are in edit mode and that sort of locks things
up until you do hit enter. so i don't think this would be a viable solution.
i would recomend that you read up of data validation. this is what data
validation is for. insuring correct input. and with data validations you
might be able to select the correct input from a VD drop down.

Regards
FSt1



"jayklmno" wrote:

Is there a way to capture what the user types into a cell before they hit
enter? I would then feed this data into a lookup to prompt the user with the
correct cell input without having to type the whole thing everytime.