formatting a text box with VBA

[sunilmulay]

Hi there

I have a text box on a sheet, and am trying to format it using VBA. I want to set the fill and font colours. I tried something like:

With shape("textbox20").font
.colour = XXXX
etc
End With

and

With shape("textbox20").interior
.colour = XXXX
etc
End With

....but I'm clearly not doing the right thing.....!

Can anyone show me how to do this?

BTW, the reason I want to use code, is that the formatting is conditional to certain criteria ie. conditional formatting on a text box.


Thanks in advance
Sunil

 

[sunilmulay]

many thanks!