98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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?
Excel
What is VBA?
Ms Excel VBA
What is an object?
VBA
would the VBA course be a benifit to me for management information daily & monthly reports ?
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
master slide
How to create a new one
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
Levels
How do levels work in the outline view?
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.
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.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |