Autofill specific textboxes in userform from sheet, and back

[Harry_1101]

Hello,
I have data in only 2 rows. Row 1 are headers, Row 2 is the data.
I also have several userforms containing a variety of txtboxes
Some of the textboxes are the headernames preceded by tb
Depending on the tbname I want to fill it’s value from the corresponding sheetdata.
If the value is changed in the userform, write it back to the correct spot in the sheet.
At this point I'm stock, cannot get the textbox name to be userform1.("tb" & (Sheet2.Range("A1").Offset(0, i).Value) to work
What would be the correct syntax for this?

[AlphaFrog]

Header from A1 and Value from A2

Please Login or Register  to view this content.

[Harry_1101]

I knew it was simple, thanks.