Multiple TextBox Input From Runtime Records On Userform

I have got multiple records displayed on a userform at present, where traversing through a for loop creates the required amount of TextBox's at runtime displaying the current data from the associated cells.

I want to display the records in the userform so via TextBox's so that the user can view their input and ammend where necessary.

My problem is trying to identify each approriate TextBox to the concerning cell.

I have now solved this issue by using an Excel Spreadsheet 11.0 object from the toolbox under 'additional controls' within the toolbox menu.

This does exactly what I want as I have simply linked the new object to read and write the specific range back and forth.

What an excellent facility, however it seems strange that it is so hidden!

Anyway Thanks.