Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » EXCEL Chart names

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

EXCEL Chart names

Resolved · Low Priority · Version 2007

Reply Wed 25 Jan 2012, 13:57Delegate Roger said...

Roger has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

EXCEL Chart names

I want to manipulate some charts in VBA.
As far as I can tell, EXCEL names the charts "chart1", chart2" etc. If I have several charts in a spreadsheet, how can I find out the number that EXCEL has given it?

Thanks

Roger

For upcoming training course dates see: Pricing & availability

Reply Fri 27 Jan 2012, 14:00Trainer Anthony said...

RE: EXCEL Chart names

Hi Roger, the quickest way to do this is to select the chart and use:

MsgBox ActiveChart.Name

Think about looping through the collection of charts in a workbook testing for a particular chart name and manipulating accordingly.

Hope this helps,

Anthony

VBA articles

· Step Into The Unknown With VBA
· Starting Out With Excel 2007 VBA Using The Macro Recorder
· How To Find A Good VB For Access Trainer
· Why Use VBA In The Office 2010 Suite?
· Microsoft Excel, Tailor-Made For Your Business Thanks To VBA

Please browse our web site to find out more about
vb for access trainer and other Microsoft training courses.

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips