value to textbox

[kaaja]

Hi

I get values from an ini file wich i read in to an array. How do I get the values to right textbox? I use VBA. It's about 50 values...


Kaaja

[kfcSmitty]

Dim I as integer
 
for i = 1 to ubound(array)
textbox1.text = textbox1.text & " " & array(i)
next

will place easch item in the array into a textbox, with a space inbetween each.

If you want a blank line intead of a space, replace " " with vbCrLf

[kaaja]

Thats not what I'm looking for. I want the text in seperate textboxes. Each line into a specific textbox. But the line can be located where ever inte the array.

[kfcSmitty]

how are you deciding which textbox each line goes into? How many textboxes do you have?

[Bartender]

If I understand you correctly, its the same as above, but with just a slight difference.

Dim ii as Integer
for ii = 1 to ubound(array)
Range("A1").Select 'or whichever cell to start
ActiveCell.Offset(ii-1,0).Select 
'Offset(row, column) so you can decide the direction 
'the cells are read into... horizontal or vertical (which I have it set to)
ActiveCell.Value = array(ii)
next ii

Hope this is what you're looking for.