I have a listbox (listBox1) that is populated by selecting items in another
listbox (ListBox).
I am trying to get ListBox1 to load into a temp variable (VtempN) so that I
can load the data into a cell once I have opened a worksheet. I tried to
load the cell with just the listbox1 data ( i.e. Range("B43").Value =
ListBox1.List), but it doesn't show the data. I even tried to redevelop the
list as shown. any help would be appreciated.

Dim n As Long
If List_AddFrom.ListIndex = -1 Then Exit Sub
For n = 0 To List_AddTo.ListCount - 1
If List_AddTo.Value(n) = True Then
VtempN = List_AddTo.List(n)
'
End If
List_AddTo.List(n) = VtempN + 1
Next n
MsgBox VtempN