Can I reference a textbox in a formula in Excel
Can I use a text box in a formula ie. copy the contents automatically to
another sheet. |
Can I reference a textbox in a formula in Excel
The easiest way to implement this is to have a macro copy the text from the
textbox and store it in a cell. The formula could then reference the cell in the usual way. Sub dural2() Dim s As String s = "Text Box 1" Sheets("Sheet1").Shapes(s).Select Range("Z100").Value = Selection.Characters.Text End Sub -- Gary''s Student - gsnu200821 "SteveW" wrote: Can I use a text box in a formula ie. copy the contents automatically to another sheet. |
All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com