VBA Excel 2010, 2013 and 2016 Tutorial in PDF
This tutorial is for beginner Excel users who want to use the VBA programming language to develop basics applications in Excel 2010, 2013, or 2016.
Table of contents
- Introduction
- Absolute and Relative References
- Using Absolute References
- Using Relative References
- Editing a Macro
- Repeating an Action
- Using Variables
- Running a Macro from a Toolbar Button or Control
- Controls
- Changing a Shortcut Key
- Deleting a Macro
- Saving an Excel Workbook with Macros
- Setting Macro Security Levels
RECORDING A MACRO
This dialog box allows you to choose a macro from the list. This list is made up of all the known procedures of Visual Basic either in all open workbooks, or in the workbook specified thanks to the drop-down list at the bottom of the BDi.
After selecting the macro, click on the Run button, you can see that your operations are repeated.
EXAMINE THE MACRO PRODUCED
It is necessary to be able to examine what Excel has memorized according to the recorded actions. In particular, this examination is necessary if the execution of the macro does not produce the desired results: it is probably that a parasitic action has been recorded and it will be necessary to remove what represents it in the recording. Another reason to examine the macro as it is saved is to be able to modify it. Minor changes you may want to make come from the very process of registration:
suppose that, wanting to select the cell A3, you first select, after a hesitation, the cell A4; of course, you will correct and click on A3. But Excel will have recorded two selection operations and it will be advisable to delete the selection of A4. So a first reason for modification is to prune the macro from unnecessary operations.
Another, much more important, reason for modification is to change the behavior of the macro to make it more ergonomic, or to handle other aspects of the application.
Download VBA Excel 2013 Tutorial in PDF, free training document intended to beginner users on 10 pages.
| Size | 421.674 Kb |
|---|---|
| File type | |
| Downloads | 2044 |
| Created | 2018-05-23 |
Others VBA tutorials
Others related eBooks about VBA Excel 2010, 2013 and 2016 Tutorial in PDF
-
Office 365: Migrating and Managing Your Business in the Cloud
Written for the IT professional and business owner, this book provides the business and technical insight necessary to migrate your business to the cloud using Microsoft Office 365. This is a practical look at cloud migration and the use of different technologies to support that migration. Numerous ...
-
Word 2013 Keyboard Shortcuts
Free Microsoft Word 2013 Keyboard Shortcuts in PDF for download ,a free training document under 20 pages to make Word easy to use and understand....
-
Pivot Tables in Microsoft Excel
The following is a list of items you should check before creating a Pivot Table, PDF tutorial under 9 pages for beginners....
-
Advanced Microsoft Excel 2013
Download free Microsoft Excel 2013 advanced Tutorial , course tutorial training, a PDF file in 87 pages for 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....
-
Microsoft Excel 2016 Course for Beginners
Looking for Excel 2016 tutorials? this page is a free training document of Excel 2016 courses, in pdf....
-
Beginning Excel 2019
Download free course Beginning Excel 2019, pdf file on 387 pages by by Noreen Brown, Barbara Lave, Hallie Puncochar, Julie Romey, Mary Schatz, Art Schneider, Diane Shingledecker....
-
Office 365
Written for the IT professional and business owner, this book provides the business and te..., download free Office tutorial in PDF (680 pages) created by Don Crawford ....
-
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....
-
Excel 2016 Shortcuts
With this reference, you will learn how to use easily Microsoft Excel 2016, all keyboard shortcuts that you need to work as a professional. Free training document in pdf designated to beginners....