Excel VBA- How to do autoselect in a listbox

  • Thread starter Thread starter venkchar
  • Start date Start date
V

venkchar

Hi

Could you pls. let me know how I can do auto select in a listbox

If I have 4 items in the list box say a) apple

b) ball
c) cat
d) dog

When I type the first character of an item say d then it should
populate that item.

Any inputs will be appreciated.

Thanks
Venky..
 
Use the ListBox Change event :-

Private Sub ListBox1_Change()
MsgBox (ListBox1.Value)
End Sub
 
Back
Top