Excel VBA - what can it do?

TrustPilot

starstarstarstarstar Excellent

Forum home » Topics » Excel VBA - what can it do?

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!

Related forum posts:

Excel VBA

What is the code to activate a drop down in the 'page' section of a pivot table, then choose an item from the list?

Read forum post

 

Excel

What is VBA?

Read forum post

 

Ms Excel VBA

What is an object?

Read forum post

 

VBA

would the VBA course be a benifit to me for management information daily & monthly reports ?

Read forum post

 

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

 

Related articles

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

 

 

Live dates & prices

 

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

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

Frequently Asked Questions
What does 'Resolved' mean?

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


TrustPilot
TrustScore 9.6       1034 reviews