1

Topic: Record in a cell from an array

Hello! Prompt as to write down in one cell, from an array of text boxes (which it will not be known how many), the example put.

2

Re: Record in a cell from an array

assei;
In the elementary case so

For I = 1 To Text1.Count
xls. Sheets ("List1").cells (I, 1) = Text1 (I - 1) ' in cells to add the data from an array of Text1 (I)
Next

And it is better to generate "a vertical" array from values of Text1 and to write down its one assignment.

3

Re: Record in a cell from an array

Kazan the matter is that it would be desirable all data to write down from an array in one cell

4

Re: Record in a cell from an array

What for?! Whether cells that is a pity smile
So it is possible

ReDim a (0 To Text1.Count - 1)
For I = 0 To UBound (a)
a (I) = Text1 (I)
Next
xls. Sheets ("List1").cells (I, 1) = Join (a, vbLf) ' in a cell to add the data from an array of Text1 (I)

5

Re: Record in a cell from an array

Kazan, thanks I will study