View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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