Select UserForm ListBox Value For Closed WB Input

Hi all,

Seems my problems are never ending.

Using a userforms listbox item. BTW only 1 item is listed. I'm trying to select that
item with code so the value/text can be copied over to an previously closed workbook(WB). Currently, I'm trying to select the item using the following:

Dim LB as string
Me.ListBox5.Selected(Me.ListBox5.ListCount - 1) = True
LB5 = Me.ListBox5
'more code then
Msgbox LB5
Sheets(X).Cells(FindIt.Row, FindIt.Column).Offset(0, 1).Value = LB5

It seems that the method that I'm using to select the list box items doesn't always work.
My MsgBox will return a empty box. Where if I walk through the code and manually select the listbox I will get LB5 to hold the listbox5 value.


I've been trying to figure this out over the past few days. Any help as always much appreciated.

Thanks,

BDB