TextBox from Drawing toolbar - 2 questions
 

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.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004

TextBox from Drawing toolbar - 2 questions
 

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


---
Regards,
Norman



"Stuart" wrote in message
...
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.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004

TextBox from Drawing toolbar - 2 questions
 

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

Regards.

"Norman Jones" wrote in message
...
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


---
Regards,
Norman



"Stuart" wrote in message
...
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.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.726 / Virus Database: 481 - Release Date: 22/07/2004