Excel VBA Programming for Beginners: Excel VBA 2013. Make it Easy. Practical Guide - Couverture souple

Torrance, Charlie

 
9781546832881: Excel VBA Programming for Beginners: Excel VBA 2013. Make it Easy. Practical Guide
Couverture souple
ISBN 10 : 1546832882 ISBN 13 : 9781546832881
Editeur : CreateSpace Independent Publishing Platform, 2017

Synopsis

This book is a guide on how to create VBA (Visual Basic for Applications) Macros with Microsoft Excel. The Author uses MS Excel 2013. You will learn how to set up everything and to access the VBA editor. You are then guided on how to use variables of different data types in VBA and arrays for storage and retrieval of data. The various operators which are supported in VBA have been discussed in detail. Functions and Subroutines have not been left out. You will know the difference between the them, how to use them and the suitable areas to apply each of them. With VBA, you can create macros capable of making decisions. This book guides you on how to use decision making statements in VBA. In VBA, you may need to work on a group of cells, particularly by applying a single action to a number of cells. This book guides you on how to use loops so as to achieve this. User forms in VBA have also been explored. You will know how to create user forms and use them to populate data in Excel. You are also guided on how to generate text files and write to them from Excel. The process of generating charts from Excel data in VBA has been discussed. Events, and the various error handling techniques in VBA have also been explored. The following topics have been discussed in this book:- Getting Started- Variables and Data Types- Arrays in VBA- Operators in VBA- Functions and Subroutines- Decision Making Statements and Loops in VBA- User Forms in VBA- Working with Text Files- Creating Charts- VBA Events- Error Handling in VBA

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Éditeur
CreateSpace Independent Publishing Platform
Date d'édition
2017
Langue
anglais
ISBN 10 
1546832882
ISBN 13 
9781546832881
Reliure
Broché
Nombre de pages
138
Coordonnées du fabricant
non disponible
Personne responsable
non disponible