Giordano Bruno
Well-known Member
- Joined
- Jan 7, 2007
- Messages
- 1,345
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?
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?