TextBox from Drawing toolbar - 2 questions

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

Xl2000

I have a Drawing toolbar textbox placed over the range "C26:L65" on a
sheet. If I right click the textbox and choose "Format Text box", then my
only option appears to be to change Font.

1. I'm sure I've seen other options on other occasions. What am I doing
wrong, please?
2. Programmatically, how do I switch between the 'fill' color in the
textbox being white and a light blue, please?

Regards.
 
Hi Stuart,

(1) Allow the mouse to hover over the border of the textbox. When the
cursor changes to the cross-hair format, right-click and you will access the
multi-tab format options.

(2)

Sub Tester()

With ActiveSheet.Shapes.Range("Text Box 2")
.Fill.Visible = msoTrue
.Fill.Solid
.Fill.ForeColor.SchemeColor = 7 'or 1 for white
End With

End Sub
 
Many thanks.
Because I couldn't access all the format options, I couldn't
record a macro.

Regards.
 
Back
Top