Linking TextBox to a cell -- Urgent

  • Thread starter Thread starter baaul
  • Start date Start date
B

baaul

How do I Link a TextBox to a Cell in Microsoft Excel. The TextBox on
Sheet1 contains texts which need to be linked to a cell on
Sheet2....i.e. I need the cell in sheet2 pulling the content from the
TextBox. Thanks!!!
 
Right click on the textbox - Properties.
Next to "Linked Cells" type in the address of the cell you
want to link.

Best regards

Wolf
 
You may also select the cell, then in the formula bar enter =Sheet1!A1 or
whatever the reference is.
 
Not getting the "properties" option when right clicking on the object
(TextBox). TextBox.text needs to be linked to a cell.

However, I am able to link a cell to a textbox object by:

1. Selecting the Text Box, and then...
2. In the Formula bar, created a link to a cell by typing = and then
selecting the cell. The contents of the cell are displayed in the Text
Box.

But I would like to do the process above in reverse. The cell should
display the content of the TextBox Object. Thanks!!
 
There are two textboxes that you can use.

I think you used the one from the Forms toolbar. It shows the behavior that you
describe (but don't want).

There's another textbox that comes from the ControlToolbox toolbar. This is the
one that has Properties available behind the rightclick (and has that nice two
way linkage).

Try adding one from that controltoolbox toolbar and see if you're happy. If
yes, then dump the one from the forms toolbar.
 
Back
Top