Lectricman
New Member
- Joined
- Feb 18, 2016
- Messages
- 14
Can anyone help with what I thought would be an easy job?
I would like to populate 13 TextBoxes (101 to 113) with data held in a range of cells.
The following formula does the trick on a single box, but I'm going to end up with maybe 100 or more boxes to do.
The data is held in a single row: (B15:N15).
Many thanks for any help.
I would like to populate 13 TextBoxes (101 to 113) with data held in a range of cells.
The following formula does the trick on a single box, but I'm going to end up with maybe 100 or more boxes to do.
Code:
TextBox101.Text = Application.WorksheetFunction.Text(ThisWorkbook.Sheets("Calcs").Range("B15").Value, "[h]:mm")
The data is held in a single row: (B15:N15).
Many thanks for any help.