value to textbox

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 :wave:

VB Code:

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

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.

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

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

VB Code:

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.