ListBox Item Selection

[jstevens]

Is there a better way other than recursing through a ListBox Index to find/highlight a specific item?

Code: Listbox.Value = Oranges
and Oranges would be highlighted as the selected item.

Example: Listbox contains
Apples
Bananas
Oranges
Pears
Strawberries

Your thoughts are appreciated.

[HansV]

I must be missing something. Isn't the selected item in a list box highlighted automatically?

[jstevens]

Hans,

Here is an example file.

Code: Select all

Sub ListBoxItems()

UserForm1.ListBox1.RowSource = "'Sheet1'!A2:A6"

UserForm1.ListBox1.ListIndex = 2  'Item is oranges but it may not always be = 2

End Sub

EL_Listbox_Selection.xlsm

[HansV]

And the question is?

[jstevens]

Hans,

If the RowSource is modified to a dynamic range and Oranges' ListIndex changes from 2 to 5 then the code would have to be manually changed to UserForm1.ListBox1.ListIndex = 5.

The question is whether or not one can set the highlighted item to Oranges say with UserForm1.ListBox1.Value = "Oranges" or some other method.

[HansV]

Yes, you can use

UserForm1.ListBox1 = "Oranges"

This will make "Oranges" the selected (highlighted) item, regardless of its position in the list box.

[jstevens]

Hans,

That was easy enough!