vba training

Forum home » Delegate support and help forum » Microsoft VBA Training and help » VBA Training

VBA Training

resolvedResolved · Low Priority · Version 2003

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

VBA Training

Hi,
I have just completed the Basic VBA course where we learnt to create Pivot Tables through the back-end coding. Is it also possible to create Charts? What is the best way to do this?

RE: VBA Training

Hi Melanie, thanks for your query. We code a chart on our advanced VBA course, but the quickest way for you to experiment with this is to record the creation of a chart using the macro recorder and then examine the code. Be warned, that in Excel 2003 the macro recorder does not "drill down" as far as it does in later versions, so if you record yourself modifying, say, the removal of tick marks on the x-axis of your chart it will fail to translate this into code. The code we use on our course covers this sort of detail.

Hope this helps,

Anthony

Thu 18 Aug 2011: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

VBA tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips


Server loaded in 0.13 secs.