View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sbcxp@msn.com is offline
external usenet poster
 
Posts: 2
Default Select in Listbox using keystrokes

H

I have a ListBox in a UserForm that holds several elements, like

Englan
Leg
Lisabo
Londo
Madri
Mila
etc..

I would like to be able to select an entry by typing the name in a text-box I have placed above the Listbox. It should highlight the word I type in the listbox

Normally, by using keystrokes in the Listbox, typing "L" will highlight the first word with beginning with L. Typing "E" will highlight the first word beginning with "E". I would like the form to behave in a way so if I type "LE" it highlights the first word beginning with "LE" and so on

Is there a way to do that in a UserForm

//Sore