Find default value in a ListBox

[Giordano Bruno]

I have two ListBoxes on a userform. Selecting a value in ListBox1 puts a value into a cell. This in turn creates a value in a cell read by ListBox 2. The code then re-initializes ListBox 2 and the matching item is highlighted in ListBox2.
When I try to identify the highlighted value in ListBox 2 my code returns "". If I click the highlighted value first, the code then returns the highlighted value.
My understanding is that the ListBox2.value returns only the selected value, but not the default value. It seems silly that to make the code work, I have to click an already highlighted item. Can anyone suggest a solution?

 

[GWteB]

My understanding is that the ListBox2.value returns only the selected value, but not the default value.

The "default" value of a ListBox is empty ("") until user makes a selection. In cases of a MultiSelect ListBox the Value property will be empty also.

The code then re-initializes ListBox 2 ......

.... meaning clearing all items?

.... and the matching item is highlighted in ListBox2.

... how does your code determine to highlight the right item?
When there is just one item in your ListBox you might use this

    ListBox2.Selected(0) = True

 

[Giordano Bruno]

Thanks for your reply GWteB and for confirmation that the highlighted item is not "selected". It looks suspiciously like a bug to me. I think the workaround must be to ensure that there is no blank item that can be selected and then to check if the "selection' is empty and if so to take instead the value that the ListBox read to take the highlight.
Your comments are much appreciated.

 

[GWteB]

You are welcome and thanks for the feedback.