listbox to array to excel row

  • Thread starter Thread starter Doug Glancy
  • Start date Start date
D

Doug Glancy

Dim temp(Me.TimeIncrementListBox.Items.Count) As String
Dim i As Int32
....
For i = 0 To UBound(temp) - 1
temp(i) = CType(Me.TimeIncrementListBox.Items(i), String)
Next
xlSheet.Range("X10").Resize(1, Me.TimeIncrementListBox.Items.Count).Value =
temp

The above works but,
Can I transfer the contents of the listbox directly to the Excel range,
without the array?
Can I transfer the contents of the listbox into the array in one swell foop,
without the loop?

Humbly,

Doug Glancy
 
Doug,

I doubt it, however how much time in nanoseconds do you think that this
take, while when there is a method which does it in one time, would do it
probably in the same way.

I would not take to much time to investigate this kind of things.

Just my thought,

Cor

"Doug Glancy" .
 
Back
Top