I want to copy a value from one textbox to several others, like:
TextBox2.Value = Textbox1.Value
TextBox3.Value = Textbox1.Value
TextBox4.Value = Textbox1.Value
etc up to 30
How can this be done by using a For Next loop?
For i = 1 to 30
"TextBox" & i & ".Value" = TextBox1.Value
Next i
TextBox2.Value = Textbox1.Value
TextBox3.Value = Textbox1.Value
TextBox4.Value = Textbox1.Value
etc up to 30
How can this be done by using a For Next loop?
For i = 1 to 30
"TextBox" & i & ".Value" = TextBox1.Value
Next i
Comment