Finding a value from an Index?

  • Thread starter Thread starter guruman
  • Start date Start date
G

guruman

Hi,

I have a list of items that are selected on a regular basis right no
in a drop down menu. I want to change this so that when I begin to typ
the item, it will jump down to that item (similar to using the hel
function in excel, you type "cou" and it jumps to count).

So I have the list of items that I want to be looked up on a seperat
tab, I was wondering how to go about putting this function in.

Thanks
 
Guru,

If you're typing the "cou" into a cell, I don't imagine it can be done, as
macros have no control during Enter or Edit mode. You could use a text box
from the Control Toolbox. There's an event that fires for pretty much
anything the user does with the text box. I think there's even one for when
the user looks at it. You would write an event routine that would look at
the characters in the text box, and scan the column, and select the
appropriate cell.
 
Back
Top