Listbox item Highlighted but not Selected

I have a form with two single-select Listboxes. When the first one, lboCat, is clicked, it selects the first item in the other listbox by:

Please Login or Register  to view this content.

However, although the first item in the list is visibly selected, the lboSubCat.Value property is usually blank. (And no, there isn't any "" in the list).

How can I return the actual value that's selected?

Is there a better way to select the first item in the list? (The list of items changes depending on what's selected in lboCat.)

Sorry, that doesn't seem to work.

Here's an odder symptom: The text of the list comes from a cell on another worksheet, so I tried doing this:

Please Login or Register  to view this content.

But that doesn't work either.

I know this is a late add on. But I had a similar issue. Where you used Listbox.Selected(X) = True to highlight the row but the Listbox.value was null or the original row that was previously selected.

I resolved it by using:

Listbox.Column(0, I)
Where I is the index value

To get the listbox value of the first column.


Hope this helps.

MM