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 t
be) = Textbox1.value

etc.

krhyme Wrote:
Hello fellow Excel-ers!!

What is the best way to link a text box in a VB form to a cell in a
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 wan
cells in excel to always be updated automatically.

What is the best strategy??

Thanks in advance

--
madblok
-----------------------------------------------------------------------
madbloke's Profile: http://www.excelforum.com/member.php...fo&userid=1442
View this thread: http://www.excelforum.com/showthread.php?threadid=39614