UserForm - How to retain wrksht data in userform and reverse

Yes you are correct.. You would need a sub for each textbox for real time updating and that would not be good for 190 textboxes..

alternatively you could have an update button and use a looping routine to iterate

Sub UpDateSheet()
for x = 1 to 190
sheet1.cells(X,1).value = Me("Textbox" & X).Text
next x
End Sub