userform text box fill selected by a variable

[Steve001]

Afternoon all

stuck again if some can help me out,

I have a userform with several text boxes on it ie a 7 x 3 grid

I want to be able to populate the contents depending upon a variable

for example if I have

var = 3
string1 = "part1"
string2 = "part2"

so this would populate row 3 on my grid with 3 part1 part2

if I had

var = 1
string1 = "part1"
string2 = "part2"

this would populate row 1 on my grid with 1 part1 part 2

I would like to have 1 piece of code that looks at the variable then decides rather than lots of if statements - so I can use the same code for all the boxes

hope this makes sense

PS please can you put comments on so I can under stand please

Steve

 

[mikerickson]

I would start off by naming the text boxes in a way that reflected their position on the grid. For this example,

TextBox1_1 TextBox1_2 TextBox1_3
TextBox2_1 TextBox2_2 TextBox2_3
...

Then code like this would do what you want.

Dim var as Long, String1 as String, String2 as String

Me.Controls("TextBox" & var & "_1").Text = var
Me.Controls("TextBox" & var & "_2").Text = String1
Me.Controls("TextBox" & var & "_3").Text = String2

 

[Steve001]

Hi Mike sorry for the late reply

Working thank you

Steve