S SteveW Dec 19, 2008 #1 Can I use a text box in a formula ie. copy the contents automatically to another sheet.
G Gary''s Student Dec 19, 2008 #2 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
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
