View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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?