1 / 10

Introduction to VBA

Introduction to VBA. What is VBA?. VBA stands for Visual Basic for Applications . It is a programming language used exclusively by the Microsoft Office to extend abilities of Microsoft Office Application .

melanie-rosales
Download Presentation

Introduction to VBA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introduction to VBA

  2. What is VBA? • VBA stands for Visual Basic for Applications. • It is a programming language used exclusively by the Microsoft Office to extend abilities of Microsoft Office Application. • In Excel it is used when you need something more complex than Excel's formulas and functions allow. VBA allows you to create very sophisticated Excel spreadsheets. • VBA is different from VB 6.0 or VB.NET

  3. Visual Basic (Definition) • What is Visual Basic? • Visual Basic is a "visual programming" environment for developing Windows (also Web now) applications. Visual Basic makes it possible to develop complicated applications very quickly. • Visual Basic is "event-driven” programming language. • You must have Visual Studio installed in your computer in order to write the code.

  4. Visual Basic(History) • History of Visual Basic • Microsoft first released Visual Basic in 1987. It was the first visual development tool from Microsoft, and it was to compete with C, C++, Pascal and other well-known programming languages. • From the start, Visual Basic wasn't a hit. It wasn't until release 2.0 that people really discovered the potential of the language, and with release 3.0 it had become the fastest-growing programming language on the market.

  5. Visual Basic (History) • Approximate year in which a new version of Visual Basic was released: • 1991, VB1 • 1992, VB2 • 1993, VB3 • 1996, VB4 • 1997, VB5 • 1998, VB6 • 2001, VB.NET

  6. VB.NET • Visual Basic .NET (VB.NET) is an object-orientedcomputer language that can be viewed as an evolution of Microsoft'sVisual Basic (VB) implemented on the Microsoft .NET framework.

  7. Visual Basic vs. Visual Basic for Application For VB 6.0, VB.NET or VBA, they all are based on Visual Basic Language!!!

  8. VSTO(Visual Studio Tools for Office) • VSTO, or Visual Studio Tools for Office, or Microsoft Visual Studio Tools is part of Microsoft's Visual Studio .NET tools suite and supports the Microsoft .NET Framework. • To use VSTO, you need to have visual studio .NET installed in your computer. • It is used by developers to write code connecting to Microsoft Office Word, Excel and Outlook applications. • It is an alternative to Visual Basic for Applications, or VBA

  9. Example: Excel VBA • As example, we will build a UserForm that allows users to enter the contact information into a form and save to an Excel worksheet. • What you have to do is just open an Excel. • In the "Tools" menu, select "Macros" and then "Visual Basic Editor". • Go to the "Insert" menu and click on "UserForm". A blank user form and a toolbox will appear. • Put objects you need on to the form • Write VBA code for your button • Please see http://spreadsheets.about.com/od/excel101thebasics/l/blexuserform1.htm for more information on this example.

  10. For more information…. • Search by any search engine using keyword such as “ VBA, Tutorial” • Or Go to http://spreadsheets.about.com/od/excel101thebasics/l/blexuserform1.htm for information of Excel VBA • Or any Microsoft Office book (look at VBA section), VBA book • Or using “Help” (by press F1) in MS office applications. Enter keyword you are looking for.

More Related