Text box linked to excel

Hello fellow Excel-ers!!

What is the best way to link a text box in a VB form to a cell in an excel spreadsheet:

I have a userform with an adresse of a property ( street name, city...) I want the user to only modify the data in the user form but I want cells in excel to always be updated automatically.

What is the best strategy??

Thanks in advance!

Have a button on the userform, and code along the lines of

Private Sub Userbutton1_click()

Worksheets("<name of worksheet>").cells(<cell where you want data to be>) = Textbox1.value

etc.

Originally Posted by krhyme

Hello fellow Excel-ers!!

What is the best way to link a text box in a VB form to a cell in an excel spreadsheet:

I have a userform with an adresse of a property ( street name, city...) I want the user to only modify the data in the user form but I want cells in excel to always be updated automatically.

What is the best strategy??

Thanks in advance!