Introduction to VBA

Introduction to VBA - Introduction to VBA and Macros What...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Introduction to VBA and Macros What is VBA? What is VBA? o VBA stands for Visual Basic for Applications o VBA is a programming language o Works in the background for all Microsoft Office applications (Excel, Word, Access, etc.) o Works in conjunction with Microsoft Office applications o Allows users to create automatic procedures Why use VBA? o VBA can automate certain tasks, saving time and effort o VBA can enhance the normal capabilities of Excel o VBA allows users to easily perform tasks that otherwise would be difficult to perform How is VBA accessed? o To open the VBE (Visual Basic Editor) within Excel (note that Excel must be open) Alt + F11 Developer – Code – Visual Basic Developer tab o File – Options – Customize Ribbon – Select Developer (within the Main Tabs area) – Click OK Software development Key development goals o Automate tasks o Achieve a certain goal o Produce accurate results o Offer an easy to use and easy to understand user interface
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/06/2011 for the course ACIS 2504 taught by Professor Mtgriffin during the Fall '08 term at Virginia Tech.

Page1 / 2

Introduction to VBA - Introduction to VBA and Macros What...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online