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:
Printable View
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.