Excel VBA Programming for Beginners

Excel VBA 2013. Make it Easy. Practical Guide

By: Charlie Torrance

Write A Review

Paperback | 12 June 2017

At a Glance

Paperback
138 Pages

Dimensions(cm)
22.86 x 15.24 x 0.76

Paperback

$24.75

or 4 interest-free payments of $6.19 with

Ships in 10 to 15 business days

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

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.