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.

Size : 878.189 Kb
File type : pdf
Downloads: 1492
Created: 2018-05-23

Others VBA Tutorials

Excel VBA tutorial for professionals

Learning access-vba PDF course

VBA API Tutorial

VBA Tutorials for professionals

VBA Excel 2010, 2013 and 2016 Tutorial in PDF

Others related eBooks about Introduction to Excel VBA Macro programming

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 PowerPoint 2013 step by step

This courses is designated to beginning-level and intermediate-level computer users. It teach you some skills that can be used to make a beutiful presentation....

How to Create Professional Reports and Documents in Microsoft Word

This is a free Microsoft Word PDF tutorial in 10 chapters and 39 pages. This course aims to give students the basics of Microsoft Word concepts. ...

Microsoft Excel 2007 Advanced - Tutorial

Download free Microsoft Excel 2007 Advanced course material and training, a 100 pages pdf documents intended to beginners....

Publisher 2016 tutorial pdf

Download free course about Publisher 2016, getting started with Microsoft Office Publisher 2016 by Bharathi G, PDF training document under 182 pages....

Introduction to Microsoft Word 2013

This support shows you in detail all the features of this new version of the popular word Microsoft Word 2013; it is for anyone wishing to discover and deepen all its features....

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....

VBA Excel 2010, 2013 and 2016 Tutorial in PDF

Download VBA Excel 2013 Tutorial in PDF, free training document intended to beginner users on 10 pages....

Microsoft Excel 2013 course

Download free Microsoft Office Excel 2013 file under 505 pages,step by step to learn Excel and build your skills , course tutorial training on pdf by Curtis D. Frye....

Quick guide to Microsoft Excel 2016

Quick guide to Excel 2016 intended to beginners in order to learn the fundamentals of Microsoft Excel 2016, training document in pdf....