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?