ListIndex Property

  • Thread starter Thread starter ajbarilla
  • Start date Start date
A

ajbarilla

Is there a way in VBA code to find the value in a listbox if I know the
ListIndex number that I want to chose? For instance, if I want to
find the third value in a list box, I want to be able to find it by
using the ListIndex value of 2. Any help would be appreciated.
 
Debug.Print Me.ListboxName.ItemData(IndexNumber)

Don't forget that the first entry begins at 0.

Debug.Print Me.List.ItemData(2)

will return the value of the 3 entry in the listbox

Daniel
 
You must log in or register to reply here.

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

Selecting Listbox items in code 2
Run-time-error 1004 "ListIndex method of listbox class failed" 1
ListIndex Property in ListBox / ComboBox 3
changing Combo Box dispalyed value 1
E-mail Excel worksheet based upon selection of combo box 1
Pre-select first row in ListBox 5
weird listbox behavior 9
move item in multiselect listbox 1

Back
Top