Nicholson Solutions
computer training skills news and resources about us contact us
 
Home  

 
 
Other Topics Offered:
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Access
Microsoft Project
Microsoft SharePoint
Microsoft Outlook
Microsoft Visio
Microsoft Publisher
Adobe Acrobat
Adobe Contribute
Adobe Dreamweaver
Sage Accounts
Twitter
General computer skills
Email newsletters
 
Visual basic image

Visual Basic for Applications

 Contact us to arrange Visual Basic training

If you need to program your Excel spreadsheets to perform tasks automatically, or understand how someone else has programmed them, this course is for you.

We can also help with automating Access, Word and PowerPoint.

Classroom Based Courses

Virtual Training Topics

Case Study

Hints and tips!

More helpful VBA tips...

 

Classroom Based Courses

Click on the title to view the course outline for our classroom based course:

Visual Basic for Applications (VBA) For those of you looking to create sophisticated spreadsheet solutions our VBA course will enable you to learn how to extract and manipulate data using Visual Basic. You will also learn how to manage your Visual Basic code and distribute your application to other users.

What Clients say...

"It's a relief to get to grips with this, so that we can edit our macros at last. There's a lot more to understand than I thought. Thanks for the training!"

Virtual Instructor-led Training

You can tackle individual topics in an on-line training session with an instructor. These are interactive sessions, offered on a one-to-one basis. To see what this involves, click here or to make an enquiry by email, click on the topic title. Topics offered include:

Loop constructs in VBA Learn how to make your macros handle repeated tasks
Looping through a collection Use looping to process an unknown number of operations, e.g. loop through every sheet in the workbook, or every populated row.
Event handling Make your macros respond to user-generated events, e.g. mouse-click, or spreadsheet open.
Running code, debugging and error handling How to work out what is going on in VB code, and make it robust. Important methods for programmers.
 
Contact us to discuss your individual requirements.  

Case Study:

One of the most common reasons for people to request this course is that they have inherited spreadsheets with macros that they need to understand in order to amend them.

We are always willing to help you de-mystify these spreadsheets and enable you to take control of them.

Back to Top
Email us | Sitemap | Newslink  
© Nicholson Solutions 2012