PDA

View Full Version : Format Datalabel



Tiger Chen
07-01-2009, 01:44 AM
Can anyone format Datalabel successfully in VBA?

For example, can you use VBA to set the datalabel font into red color and Arial style?

When I do it, it changed to what I want. However, when I save it and reopen it, the color become black, the font is default, rather than Arial.

I'm using Excel 2007.

Thanks in advance.

mdmackillop
07-01-2009, 05:48 AM
Can you post a simple sample?