vba
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

VBA

resolvedResolved · Low Priority · Version 2003

replyReply Thu 23 Apr 2009, 16:30Delegate Michele said...

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

For upcoming training course dates see: Pricing & availability

replyReply Mon 27 Apr 2009, 10:39Trainer Jacob said...

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.

 

Please browse our web site to find out more about
training in excel and other Microsoft training courses.

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard