listbox to array to excel row

[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

[Cor Ligthert]

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" .

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 Glancy]

Thanks Cor. Good to know I'm on the right track.

Doug

"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

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" .

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