sunilmulay
New Member
- Joined
- Jun 6, 2009
- Messages
- 30
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:
and
....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
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:
Code:
With shape("textbox20").font
.colour = XXXX
etc
End With
and
Code:
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