Introduction to Excel VBA Macro programming

Introduction to Excel VBA Macro programming, Learn Excel tools by utilizing them in various cases, Understand the logic and syntax behind Visual Basic programming, which interacts with the Excel interface.

Table of contents

  • Goals of the Workshop
  • Workshop Structure
  • Workshop Resources
  • Case 1: Multiplication Table
  • Case 2: Percentile Calculations
  • Tutorial 1: Variables and Arrays
  • Case 3: Hello World
  • Tutorial 2: Functions
  • Tutorial 3: Loops and Decisions
  • Case 4: Gradebook Tallying
  • Case 5: Loop through Data
  • Tutorial 4: Recording Macro
  • Case 6: Select, Pull, Display
  • Tutorial 5: Userform
  • Case 7: Subway Data All-Around Analysis

Introduction to VBA

VB (Visual Basic) is a Windows application. It is a programming language, more precisely a modern object-oriented BASIC, which makes it possible to write autonomous applications, that is to say "double clickable". There is currently no version (November 2002) of Visual Basic for Macintosh, and to my knowledge, this is not the order of the day.

VBA (Visual Basic for Applications) is a subset of VB, integrated with Microsoft Office applications. VBA is less powerful than VB (no stand-alone application possible), but has the features of the associated application (Excel, Access, Word, Powerpoint, ...).

Although VB only exists for Windows, VBA is happily present in Office versions for the Macintosh.

To use VBA, you have to leave Excel in a certain way: VBA has an interface of its own, with its menus, preferences and toolbars.

It should be understood that opening Excel gives access to 2 separate software, all 2 capable of interacting with Excel objects. The first is Excel itself, the second is VBA, of course.

The existence of 2 applications is crystal clear in Windows because they appear clearly in the taskbar.

Prior knowledge

Understanding the following requires functional knowledge of Excel.
You will be able to improve your knowledge of this software by reading the content of sections on Excel 2003 and Excel 2007.

Size878.189 Kb
File typepdf
Downloads1643
Created2018-05-23
Cover of Introduction to Excel VBA Macro programming
Preview PDF

Download

  • Microsoft PowerPoint 2007

    This PDF tutorial is aimed at beginner who wants to creat their own PowerPoint presentation ,easy course with illustrative images,free training lesson under 14 pages by Dawn Rauscher....

  • Microsoft Excel 2016 Tutorial

    Download a basic pdf tutorial about Microsoft Excel 2016, free training document under 12 pages...

  • Excel Fundamentals

    Excel Fundamentals, it's a free PDF download about Microsoft Excel intended to beginners, document in 60 pages created by St. George’s Information Services....

  • Microsoft Excel for Beginners

    This is a basic computer workshop. Microsoft Excel is a spreadsheet program. We use it to create reports that need calculations and charts. In this workshop we will learn how to move around and work inside the spreadsheet....

  • Microsoft Office 365

    Download free course Microsoft Office 365, pdf file on 337 pages by Katherine Murray....

  • Guide Excel 2010

    A little guide in PDF,it will clarify the new basics features added to Microsoft Excel 2010 ,free training tutorial under 24 pages....

  • Basic Excel Skills

    This course is not intended to serve as a beginner's tutorial on Excel. Those who are new to Excel and who need a tutorial should work through abook or a CD, or take an online course....

  • Commonly Used Excel Functions

    Here are some basic formulas that are easy to do and that can give some life to an Excel sheet!, download free PDF training document under 17 pages....

  • Tutorial Access 2016 in PDF

    Download free Tutorial in PDF about Microsoft Access 2016 (course, exams and exercises), a complet training document course on 322 pages for beginners by MARY LEMONS....

  • The Beginner’s Guide to Microsoft Excel

    This is a free Excel PDF tutorial in 11 chapters and 23 pages. This course aims to give students the basics of Microsoft Excel tips and trics. ...