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

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

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

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