Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Textbox | Excel Worksheet Functions | |||
Cell that is linked to a Textbox, loses formula? | Excel Discussion (Misc queries) | |||
Formula in TextBox | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Use a formula to populate a label from a textbox | Excel Discussion (Misc queries) |