I think I know what your trying to do. The closest way That I found is
creating a form and aligning one ch size textbox in a line to appear as one
textbox and formating each box to one chr. keep tab order proper and code a
search from first chr then from two chr and so on untill match or a new entry
is required in list.
Good luck.

"Ernst Guckel" wrote:

Hello,

Is there a way to have an event fire as soon as a user starts typing data
into a cell range? IE: I can use the worksheet_Change event but it only
fires after the user presses the enter key. A form level control change
event fires once we start changing the data... This is what I want on a
worksheet... Any Ideas?

Thanks,
Ernst.