I'm trying to build kind of an autocomplete macro for excel, but I'm new at this and have been just beating my head against the wall.

My idea was something like:

On selection change
If target cell is (sheet 1) a1 then
do untill onkey "enter" or selection change
onkey "any key"
vlookup(sheet 1 a1, sheet 2 a1-b100,2,false)
?
end

Trying to get it to, when cell a1 is selected it will use vlookup every time you press any letter or number key.
The "?" is cause I don't konw how to display the result. I would like it to show it the same way the normal autocomplete function does. If thats too tough just putting it in another cell will work.

My plan is to use this as an autocomplete function so my employees don't have to search through a list of 3000+ customers everytime thy're on a job.

Anyway, thats kinda what I want, just can't get the codes right. Never actualy use those ones before.