text over shapes

  • Thread starter Thread starter zackb
  • Start date Start date
Z

zackb

Is it possible to have text from a cell overlap a transparent/gradient
filled rectangle shape?
 
Zack,

Not sure if this is what you really want by did you know that you can give a
shape a formula that displays the value of a cell?

You can do this from the formula with the shape selected or here is a sample
from code...

Sub MakeShape()
ActiveSheet.Shapes.AddShape(msoShapeOval, 1, 25, 200, 50).Select
With Selection
.Formula = "$A$1"
.AutoSize = True
.ShapeRange.Fill.ForeColor.SchemeColor = 26
.ShapeRange.Fill.Transparency = 0.33
End With
End Sub
 
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

draw shapes in excel using the keyboard 1
Add and edit a shape in VBA 1
Basic Shapes 2
Shape Merge 0
Shape Arrays VBA 0
Rectangle shape round top corners only 1
send color filled shape behind text 3
PowerPoint powerpoint text Overflow 0

Back
Top