Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Temp List to cell
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using obj.Namespace(sourceFileName) Namespace(DestinationFilename).Itemsand then opening the xls file which creates a Temp Folder inside Temp | Excel Discussion (Misc queries) | |||
Copying cell formatting when selecting from a list | Excel Discussion (Misc queries) | |||
Copying cell contents to a list | New Users to Excel | |||
Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
Temp File | Excel Programming |