Please use [ VBA ] tags when posting VBA code.

ListBox.Value will return the currently selected item, as long as MultiSelect is set to fmMultiSelectSingle.