Reference Textbox from cell

  • Thread starter Thread starter RLang
  • Start date Start date
R

RLang

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.
 
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
 

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

userform exception error 4 textboxes 7
Textbox reference 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
textbox Do nothing 1
Excel Displaying content from excel sheet onto textbox in userform 0
Force to update textbox value to cell 1
ReadOnly TextBox from ControlSource 6
finding where text wraps in a textbox 4

Back
Top