OnDirty / Auto Complete

[BillJunior]

I am creating a excel sheet that has a list of about 800
names on it. I want to be able to have a seperate sheet
that I can start to type in the name and it will auto-
complete it. Is there any way that this can be
accomplished?

The auto-complete option is already on (Options --> Edit -
-> Auto Complete)

I am currently using data validation which is good but I
need a way to try and limit the amount of data they have
to sort through.

I would be willing to use code if needed and to abandon
the data validation part as it would be far more
convenient to auto-fill in the rest of what they type. I
was trying to do the code myself but I am not certain how
you could get the code to execute on every key down. Is
there a OnDirty method for a worksheet or for individual
cells?

Thanks,

BillJunior

 

[Frank Kabel]

Hi
AFAIK not much chance (besides using a self created userform).
Problems:
- Excel can't run macros while in edit mode within a cell
- The build in data -validation listbox does not allow auto completion