Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Worksheet from ListBoxes
I would like to transfer the contents of several listboxes to a temporary
worksheet for the purpose of printing a report. I suppose I could loop through the contents of the listbox, but isn't there a way to get all of it at once? My current thinking (which may be all wet) is to transfer the contents to an array then from the array to the worksheet. Thank you -- Adios, Clay Harryman |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Worksheet from ListBoxes
Clay,
Is the listbox from the Forms command bar or the Controls command bar, or is it on a user form? Are you using the ListFillRange property? You might try something like Dim V As Variant V = Sheet1.ListBox1.List Range("C11").Resize(UBound(V) - LBound(V) + 1).Value = V -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Clayman" wrote in message ... I would like to transfer the contents of several listboxes to a temporary worksheet for the purpose of printing a report. I suppose I could loop through the contents of the listbox, but isn't there a way to get all of it at once? My current thinking (which may be all wet) is to transfer the contents to an array then from the array to the worksheet. Thank you -- Adios, Clay Harryman |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populate Worksheet from ListBoxes
With ListBox1
Range("A1").Resize(.ListCount).Value = .List End With "Clayman" wrote in message ... I would like to transfer the contents of several listboxes to a temporary worksheet for the purpose of printing a report. I suppose I could loop through the contents of the listbox, but isn't there a way to get all of it at once? My current thinking (which may be all wet) is to transfer the contents to an array then from the array to the worksheet. Thank you -- Adios, Clay Harryman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate Order worksheet from Quote worksheet | Excel Worksheet Functions | |||
populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
Listboxes - populate with all worksheet names | Excel Programming | |||
Listboxes on a worksheet | Excel Programming | |||
populate one worksheet from another | Excel Worksheet Functions |