It seems to me that you are not declaring your LB5 variable. You probably want to declare it as a string, then get the value from the listbox using the .Value property. As is, LB5 is not declared a certain data type, and when you set it to your listbox it probably is using the Object data type.
Dim LB as string
Dim LB5 as String
Me.ListBox5.Selected(Me.ListBox5.ListCount - 1) = True
LB5 = Me.ListBox5.Value
'more code then
Msgbox LB5
Sheets(X).Cells(FindIt.Row, FindIt.Column).Offset(0, 1).Value = LB5
Bookmarks