Reference Textbox from cell
Put this in a regular module (adjusting names to suit):
Function TextBoxValue() As String
TextBoxValue = ThisWorkbook.Worksheets("Sheet1").txtTest.Value
End Function
You can then use this function in a worksheet formula.
Tim
"RLang" wrote in message
...
Hi Tim, I have a number of controls on the spreadsheet surface a few of
which
are text boxes. In another section of the spreadhsheet, I want to
reference
the contents of one or more textboxes in cells without adding code.
"Tim Williams" wrote:
Specifically what do you mean by "the text box" ?
Tim
"RLang" wrote in message
...
Hi, I read various methods of referencing cells from the textbox, but
I'd
like help to do the reverse.....enter a function in a cell that
references
the contents of the textbox.
Thanks much
|