ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Text Box to Excel Cell (https://www.excelbanter.com/excel-programming/278020-text-box-excel-cell.html)

Neil Bhandar

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.
.



All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com