vba class for updating multiple textbox that share same name with cell (name manager).

[polonic]

hello to everyone.
I was trying to find on the formum, but without luck, a vba class that update text in cell (cell that is having a name manager) from a textbox that is having the same name as the cell (ex. excel cell and textbox are named customer_name).

because I have like 800 textboxes, I would like to have some class that triggers the event for when a textbox is update.
at the moment the update look like this

Private Sub TextBox1_Change()
ThisWorkbook.Sheets("Sheet1").Range("TextBox1").Values = TextBox1.text
End Sub

thank you in advance