Hi,
I have a drop down list in a cell that I use for selecting a user name.
There is a long list of user names, and I am wondering if there is a way to design the drop down (probably through VBA) so that I can type a letter in that cell to help me sort through the list of user names. For instance if I type the letter "j" it will take me directly to the section of the list that has names starting with "j".
Thanks for any insight,
Plix
I have a drop down list in a cell that I use for selecting a user name.
There is a long list of user names, and I am wondering if there is a way to design the drop down (probably through VBA) so that I can type a letter in that cell to help me sort through the list of user names. For instance if I type the letter "j" it will take me directly to the section of the list that has names starting with "j".
Thanks for any insight,
Plix
