Text box reference a cell

M

Mike

I have a text box that I want to be equal to a cell. I posted a similar
problem yetsreday about colors in two objects, but now I need the syntax for
textboxes. Here is what I have so far:

ActiveSheet.Shapes("Text1").Selection.Characters.Text =
Sheets("COLORS").Range("C9").Text

but it is having a problem with the syntax before the = sign. The text box
is protected, so I was trying to avoid selecting the object.
 
H

Harald Staff

Hi

Drawing toolbar textbox ? No code needed. Just select the textbox, and enter
in Excel's formula field
=COLORS!C9

HTH. Best wishes Harald
 
Top