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
Bookmarks