Excel VBA - what can it do?

Excel VBA stands for Visual Basic for Applications. It is a programming language which is used to develop programs within Excel.

It can turn complex or time-consuming tasks into automated processes, saving time and improving the quality of reporting.

Some of the benefits of using Excel VBA include:

- Saving time on repetitive tasks by carrying them out in exactly the same way, consistently.
- Once set up, VBA allows tasks to be performed by an Excel novice through the click of a button (on the toolbar or in a worksheet).
- Doing things that are otherwise impossible in Excel like creating a new function or controlling the scroll area.
- It can be used to create an entry form or user interface.

For example;
A sales person could have a button to print out a weekly report for the current week just before attending a meeting.

A data analyst could download data and run a macro to format, delete and rearrange the data before outputting to a pivot table. All with one macro!

Other posts you might be interested in:

RE: linked sheets

Hi Colin Thanks for your question. You can go to Edit - Links in the file that contains the links in order to manage how the links in the workbook operate. Amanda
Read forum post

master slide

How to create a new one
Read forum post

RE: "Notes" summary on Outlook Summary

Dear Christiana Thanks for your question, it has had us scratching our heads! Can you just confirm that this happens to you at work or when you attended the course? Also, could you actually see the notes folder in the Outlook Summary page? Rgds Jacob
Read forum post

Levels

How do levels work in the outline view?
Read forum post

How To Use VBA To Create A Data Entry Box In Excel

Have you ever wondered how to create a data entry box to enter data into a particular cell in Excel? This article describes how to create an input box in Excel using VBA and the exercise is a good illustration of VBA usage for the newcomer.
Read article

An Introduction To The Excel VBA Editor Screen

Learn how to open the VBA editor in any version of Excel, identify the parts and create a simple example of VBA coding. The Excel VBA editor screen is very similar in Word, PowerPoint, Outlook and Excel, but this article will focus on Excel.
Read article

Training courses