Text box reference a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi

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

HTH. Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maintaining Text Box Font Setting through VB 4
Align text in a text box 2
Copying Multiple Text Boxes 3
how to unprotect text box 2
protecting a text box in spreadshhet 2
Move data from text box to cell 1
Syntax for selecting a textbox within a chart? 4
Excel macro 0

Back
Top