If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking TextBox to a cell -- Urgent
Right click on the textbox - Properties.
Next to "Linked Cells" type in the address of the cell you want to link. Best regards Wolf -----Original Message----- 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!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . |
#2
|
|||
|
|||
Linking TextBox to a cell -- Urgent
You may also select the cell, then in the formula bar enter =Sheet1!A1 or
whatever the reference is. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "Wolf" wrote in message ... Right click on the textbox - Properties. Next to "Linked Cells" type in the address of the cell you want to link. Best regards Wolf -----Original Message----- 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!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . |
#3
|
|||
|
|||
Linking TextBox to a cell -- Urgent
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!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
Linking TextBox to a cell -- Urgent
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. baaul wrote: 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!!! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|