Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change text in textbox in chart in Excel 2007
After I changed from Excell 2003 to Excel 2007, the following VBA code, which
changed the date in a textbox in a chart, no longer worked: Sheets("All Styles").Select ActiveChart.Shapes("Text Box 1026").Select Selection.Characters.Text = Range("Date").Value The macro recorder doesn't record anything when I try to use it to get some code. Any ideas for fixing this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a Textbox in a standalone Excel 2007 chart using mac | Charts and Charting in Excel | |||
Textbox on chart doesn't print in Office 2003, but does in 2007 | Charts and Charting in Excel | |||
Change text in Textbox on Chart? | Charts and Charting in Excel | |||
Change text in Textbox on Chart? | Excel Programming | |||
how can i use a function to change chart title in Excel 2007 | Excel Worksheet Functions |