Can I reference a textbox in a formula in Excel

S

SteveW

Can I use a text box in a formula ie. copy the contents automatically to
another sheet.
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using strings in vlookup function calls 5
COPY RIGHT AND TRANSPOSE 2
using the =page! feature to transpose a row to column 0
keep formula delete contents 3
Maintain cell reference after value is moved 2
evaluate a concatenate expression 3
Countif contains a word in a reference cell 3
Excel not copying formula reference to original workbook 7

Top