Linking a cell to a text box

Question

Linking a cell to a text box

Anonymous

I am trying to make a template in Excel so I can print checks. I have set up two different tabs - the first one has all of my check information it, payee, dollar amount, ect. The second tab is my check template. I am placing text boxes on the page so it matches up with my paper checks. I need to link my information on tab 1 to my text boxes on tab 2. I try and do the equal sign and click on the cell I want, but it's not working.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

Hi Shelly,

A textbox is a Shape Object.

When we insert a textbox in a worksheet, Excel gives it a name such as "TextBox 1".

There is no excel formula which has any direct access to such Shape Objects.

However, using an Excel Macro, one can capture the text box content and paste it in desired cell.

If you are interested in such a Excel Macro (VBA code), then have a look at the following site.

They have shared one such sample macro.

https://www.extendoffice.com/documents/excel/4047-excel-convert-textbox-to-cell.html

Hope this Helps.

0 comments

3 additional answers

Answer 1

Anonymous

I think they want the opposite - in the textbox have a link to a cell.

That is possible - just select the textbox by right-clicking it and (this part is important) then in the formula bar type = and then click on the cell that has the value you want to appear in the text box.

0 comments

Answer 2

Anonymous

If what you guess is true then it is very simple - as rightly guided by you.

0 comments

Answer 3

Anonymous

Hi Shelly,

Please try Rajesh's suggestion. If you still have problems, please post back to let us help you.

Thanks,

Rena

0 comments

Share via

Linking a cell to a text box

3 additional answers