Excel textbox linked to cell - thought this would be straightforward

[dwilson38550m]

Hi,

I am struggling with this (sorry). In the past I have managed to create a textbox in Excel and link this to a cell in Excel such that when the formula in the cell updates the text updates as well. Unfortunately I can't get this to work ...when I type = and try to link to a call it just shows = in the text box.

Thanks in advance.

 

[Taul]

Hi,
Are you typing the = sign in the edit line or the textbox


Paul.

 

[dwilson38550m]

Typing = in the text box. Anything you can suggest? Thanks

 

[Taul]

Hi
Click the Text Box button under Insert tab, and insert a textbox in your worksheet.
While text box is selected put your cursor in the formula bar, type in = symbol and then click on the cell you want to link to,
and finally press the Enter key.

Cheers
Paul.

 

[dwilson38550m]

Thanks, Paul, I'll give that a go. Thanks