Cell value while typing
You could try positioning a text box over the cell and catching the text as
the user types in it.
Tim.
"Cordobes" wrote in message
...
While I am entering data on a particular cell, I want a userform to go
through a list of values on a sorted database, scrolling down to those
that
contain the typed data.
Thus, excel will be suggesting me different values which I may pick or
not.
To accomplish this, I can only think on analizing the pressed keys and
paly
with the control source of the form, but can't find a method that will
tell
me the pressed key value on a cell while it is being edited, before I
press
enter.
Any suggestions?
|