Excel VBA- How to do autoselect in a listbox

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..
 
B

BrianB

Use the ListBox Change event :-

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table counting a range 1
Simulate "autoselect" in ListBox 5
Find a value in table 2
Blank item in listbox, how to remove 3
how do i find out what is uncommon in column list A1: A10 and B1:. 1
Listbox B if LIstbox A equals 3
Run select query from VBA code where criteria comes from a multi select ListBox 2
How to filter listbox data in a form? 1

Top