Passing data to a variable number of TextBoxes in a user form

[Jat999]

Hi all

I have a user form which can have up to 10 Textboxes. These are numbered Tbx1 through to Tbx10.

The user inputs a value into a seperate textbox upto a maximum of 10. For the purpose of this example, lets suggest a value of 5.

The code then needs to populate Tbx1 to Tbx5 with same data.

   For M = 1 ToNum_Mix

[FONT=Calibri][COLOR=#000000]       mix_Ctrl.Sap_Code & M = ActiveCell.Offset(0, 1).Value[/COLOR][/FONT]
[FONT=Calibri][COLOR=#000000]    Next M [/COLOR][/FONT]

Where M = User input variable
mix_Ctrl is the user form
Sap_Code"n" are the variable number of textboxes

I was trying with a loop by trying to concaternate the variable M appended to Sap_Code but Excel does not like this.

Any suggestions please?

TIA John

​

<strike></strike><strike></strike>

 

[Jat999]

No need to answer - I have solved with the following code

 Me.Controls("Sap_Code" & M) = ActiveCell.Offset(0,1).Value