| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List to Range
Hi
I have a list on a userform. I would like to transfer all of the values in the list to a range on Sheet2. Does anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List to Range
Jahsonn,
Try something like With Me.ListBox1 Worksheets("Sheet2").Range("A1").Resize(.ListCount ).Value = .List End With -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Jahsonn" wrote in message ... Hi I have a list on a userform. I would like to transfer all of the values in the list to a range on Sheet2. Does anyone know how to do this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
List to Range
Jahsonn,
Something similar to the following should work... With Worksheets("Sheet2") .Range(.Cells(2, 1), .Cells(22, 1)).Clear ' Remove formatting .Range(.Cells(2, 1), .Cells(22, 1)).Value = UserForm1.ListBox1.List ' Write .Columns(1).AutoFit End With Regards, Jim Cone San Francisco, CA "Jahsonn" wrote in message ... Hi I have a list on a userform. I would like to transfer all of the values in the list to a range on Sheet2. Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| advanced filter dialog box, "List Range" list two ranges? | Excel Worksheet Functions | |||
| List Box - For Input Range can I use named range in another workbo | Excel Worksheet Functions | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Condensing a list/range with blank cells to a new list/range without blanks | Excel Worksheet Functions | |||
| how do i define a range as a list when there is no list option in. | Excel Worksheet Functions | |||
Linear Mode
