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.