Cell value while typing
Hi
problem is what in a cell while you're in 'Edit mode' a macro (or a
userform) can't run. So I doubt this is possible
--
Regards
Frank Kabel
Frankfurt, Germany
Cordobes wrote:
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?
|