vba

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

VBA

resolvedResolved · Low Priority · Version 2003

Michele has attended:
Excel VBA Intro Intermediate course

VBA

how to create a macro to set up all the graphs in a specific worksheet with the same format

RE: VBA

Hi Michele

Further to your post about creating a macro to perfom formatting on various graphs within a worksheet this is certainly achievable.

We will need to know more however on exactly what sort of worksheet and graphs you are using and what formatting you wish to make.

Our inclination is more towards VBA solution for this but we will need to see your working files along with a description from you on the key features you require.

Once we have reviewed we will let you know to what level we can provide a solution, "does it tick all the boxes?", and the amount of work and asscoiated costs to make it happen.

If you would like to discuss this further please contact us direct.

Regards

Jacob

Sun 3 May 2009: 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.


 

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.07 secs.