99.3% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
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.
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:
What is the code to activate a drop down in the 'page' section of a pivot table, then choose an item from the list?
What is VBA?
What is an object?
would the VBA course be a benifit to me for management information daily & monthly reports ?
Other posts you might be interested in:
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
How to create a new one
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
How do levels work in the outline view?
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.
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).
Any suggestions, questions or comments? Please post in the Improve the forum thread.