Microsoft VBA Training and help

Version 1.9

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

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

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

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

The UK's most regular instructor-led training courses.
Training information · Excel london

Resolved

Replies

Title

Posted by

Andrew

Kerry

Jennifer

Jane

Command Buttons that don;t show when printed

Peter

Counters in excel

Ricci

Coding Best Practices

Georgios

Referencing Worksheets in a formula using R1C1

Martin

Coding Excel VBA from within Access

Arthur

Graphics in VBA

Nicola

Perform a macro whenever the Sheet is updated

Julian

Create a contents page

David

Variable, Variant

David

VBA

Nick

How do i create a chart?

James

Import multiple worksheets

Jeffrey

How do I do loops?

Oliver

Pivot table

Michelle

Vlookup, updating data

Gunaratnam

Opening a word doc from excel using %USERPROFILE%

Julian

Setting all variables to zero

Peter

Excel, Access, VBA

Robert

Selecting a single column in the current region

Alex

Importing files

Sunny

Perform deletions on Start up

Julian

Macros - Enabling them to work across multiple workbooks

Alex

Is there a way to speed up macros

Priya

Saved worksheet - Macro Issue

Alex

Macro Cheatsheet

Fergie

Table Macro

John

VBA Excel

Simon

How to Clear Excel ClipBoard

Sejal

VBA Errors

Michael

Duplicates

David

Excel Automatically to Format spreadsheet to e mail

John

Loop or Find

Liz

Protecting VBA code

Anton

Loop

Liz

Auto Insert Date into a Cell

Alex

Update data from Web

Louis

Automatically sending excel files through outlook

Aman

Training by application

Main information pages