Link contents of TEXT BOX object to a cell

[Bungraman]

Hi,

I have tried searching this forum for help, but some members don't clearly explain what they want in their titles , so it is easier to ask straight out.

I need some help in linking the contents of several Text Box objects to cells. For example, link the contents of Text Box 1 to cell "A5".

How is this achieved, and is the code a macro, or will it sit under the sheet code or workbook?

I know how to link a cell content to a text box by typing the cell in the formula bar when you have the text box selected ie =A5.
Is the reverse this simple?? I have tried entering =Text Box 1 in the cell thinking in line with named cells, but it doesn't work.

Can anyone please help. Thanks

 

[Claymationator]

Here are a few options for you

http://www.mrexcel.com/archive/Controls/4776.html

First result when searching Bing for "link text box contents to cell in excel"

Hope that helps.

 

[Bungraman]

Thanks Claymationator, I did find that earlier, I modified it to -

Sub SetTextBoxValue()
ActiveSheet.Shapes("Text Box 8").Select
Selection.Characters.Text = Range("A8").Value
Range("A8").Select
End Sub

But all it did was cut the text from Text Box 8 and pasted nothing into "A8". What has gone wrong?

oh... and what I need is the textbox contents to be linked to the cells, I think the code above does the opposite.


Bungra