View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Bhandar Neil Bhandar is offline
external usenet poster
 
Posts: 9
Default Text Box to Excel Cell

Yes this is possible.

Just create a text box like usual then instead of typing
the content in just say ='Sheet1'!B1

the contents of cell B1 from the Sheet 1 will show up, if
you update the contents of B1 the contents of the sheet
will change too.

HTH,
-Neil

-----Original Message-----
I would like to have a form with text boxes that a
numerical value can be entered into and it will
automatically update a cell in the Excel file the form is
associated with.

Is this possible?

Thanks

S.
.