TextBox from Drawing toolbar - 2 questions

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

 

[Norman Jones]

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

 

[Stuart]

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

Regards.