VBA Template Development & Programming: Excel, Access & Word

What is VBA (Visual Basic for Applications)?

VBA is the programming language behind the Microsoft Office macros – it enables you to build custom solutions using Microsoft® Word, Excel, PowerPoint, Outlook or Access – using the VBA language that is incorporated within all of them. Based in Cape Town, we write VBA solutions for clients across South Africa and Internationally.

Template and macro design

Many companies like using standard documents like standard letters, memos or file notes. We can program these standard document templates for you, as well as more complicated ones like the ones that are traditionally used in the legal industry, such as bills and statements.

A template can be as simple as a document containing pre-set information like company logos and address information, or it can be more complicated, with dialog boxes that pop up for the user to fill in. The more complicated ones require an advanced knowledge of programming in VBA.

Customised Excel solutions

We can program Microsoft® Excel to perform repetitive tasks using VBA code. The code can search thousands of rows of data and extract relevant information, perform calculations on this data and then return the answer that you require – all in the single click of a mouse!

Toolbars, menus and forms can be customised to suit your users. A complete office solution can be created specifically for your business needs.

VBA training and VBA step-by-step manual

We teach VBA for Word, Excel and Access, in person or online. If you prefer to learn at your own pace, our Access VBA manual is a step-by-step guide you can follow from the comfort of your own home, with help just an email away. See our manuals page for course outlines.

To discuss your VBA project or training needs, contact us today. Looking for a full system rather than a macro? See our custom database development.