| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Has anyone had problems setting the font size for a title through VBA?
I have some VBA code that makes multiple copies of a chart object and then populates the chart with series and title information. Unfortunately, the font size for the chart title keeps on getting reset to 16.5, even though I set it to 12 via VBA. I have no idea why this is, and no error is listed. Any ideas on how to fix this would be really welcome. Further details: Code used to duplicate the original chart object Set co2 = co.Duplicate Code used to rename and change font co2.Chart.ChartTitle.Text = cYNav.getName co2.Chart.ChartTitle.Font.Size = 12 where co2 is a ChartObject cYNav is an object I created to store some info. Thank you for your help. Regards, Viv. -- Viv2004 ------------------------------------------------------------------------ Viv2004's Profile: http://www.excelforum.com/member.php...o&userid=26511 View this thread: http://www.excelforum.com/showthread...hreadid=397944 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font size | Excel Worksheet Functions | |||
| Font size prints same size regardless of how I set it in Excel | Excel Discussion (Misc queries) | |||
| How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
| Changing font size in a list box | Excel Discussion (Misc queries) | |||
| Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel | |||
Threaded Mode
