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?