If you have only one column in the ListBox and the BoundColumn is set to 1,
then you can use the Value property to return the displayed value.

x = UserForm1.ListBox1.Value
MsgBox x

Would display the selected value. Also see the Selected property in VBA help.

"Marvin Buzz" wrote:

I have two listbox controls named FROM and TO
The rowsource for both is the same, but variable in length. When the user
form loads, I would like to have FROM display and select the first value in
the rowsource, and to have TO display and select the last value in the
rowsource. Using TOPINDEX causes the correct value to be displayed, but the
returned value is null.

Any suggestions please?

Thanks.

Marvin