Excel VBA - Intermediate Lessons in Excel VBA Programming for Professional Advancement: 2

By Peter Bradley

Do you work in Excel VBA Programming?

Are its complications causing you pain and distress?

You are not alone!

Many people who are using Excel VBA are struggling to get to grips with it beyond the beginner stage. As you attempt to go further and deeper into this programming it becomes more complex, leading to many people simply giving up on it.

But help is here, with Excel VBA: Intermediate Lessons in Excel VBA Programming for Professional Advancement, a book that is designed as the answer to your problems and that contains great advice and tips on:

• How to use data from Excel

• Working with loops

• Conditional statements

• Working with strings

• Error handling and debugging

• Mistakes to avoid

• And more…

Excel VBA is an exciting and productive program once you get properly acquainted with it. And if you are seeking professional advancement in your chosen career then this is a vital tool you must know more about.

Get a copy of Excel VBA today and start learning how to use this excellent programming to its full extent.

You'll be surprised how easy it will be!

 

 

• Language: English
• Publisher: Peter Bradley
• Release date: Jul 3, 2019
• ISBN: 9781393202776

Peter Bradley

Peter Bradley was the Labour MP for The Wrekin between 1997 and 2005. More recently, he co-founded and directed Speakers’ Corner Trust, a charity which promotes freedom of expression, open debate and active citizenship in the UK and developing democracies. He has written, usually on politics, for a wide range of publications, including The Times, The Guardian, The Independent, The New Statesman and The New European.

Book preview

© Copyright 2018 - Peter Bradley - All rights reserved.

The contents of this book may not be reproduced, duplicated or transmitted without direct written permission from the author.

Under no circumstances will any legal responsibility or blame be held against the publisher for any reparation, damages, or monetary loss due to the information herein, either directly or indirectly.

Legal Notice:

This book is copyright protected. This is only for personal use. You cannot amend, distribute, sell, use, quote or paraphrase any part of the content within this book without the consent of the author.

Disclaimer Notice:

Please note the information contained within this document is for educational and entertainment purposes only. Every attempt has been made to provide accurate, up to date and reliable, complete information. No warranties of any kind are expressed or implied. Readers acknowledge that the author is not engaging in the rendering of legal, financial, medical or professional advice. The content of this book has been derived from various sources. Please consult a licensed professional before attempting any techniques outlined in this book.

By reading this document, the reader agrees that under no circumstances is the author responsible for any losses, direct or indirect, which are incurred as a result of the use of information contained within this document, including, but not limited to, —errors, omissions, or inaccuracies.

Table of Contents

Introduction

Chapter One: VBA, A Primer

Macro Recorder

Security and Macro Storage

Chapter Two: How to Use Data from Excel

Property Application.ScreenUpdating

Open the Source File and Read Data

Chapter Three: Working With Loops

The For Loop

For...Next Statement

The For Each ... Next Statement

Nesting Loops

The Do While Loop

Do While...Loop Statement

Do...Loop While Statement

The Do Until Loop

Do Until...Loop Statement

Do...Loop Until Statement

Chapter Four: Working With Conditional Statements

If...Then...Else Statements

Multiple-line Statements

Nesting

Using the Not Operator

Single Line If...Then...Else Statements

Select...Case Statement

Syntax

Using the To Keyword

Using the Is Keyword

Using a comma

Nesting

Go To Statement

Select...Case Statements Versus the If...Then...Else Statements

Chapter Five: Working With Strings

Points to Remember

Original String Does Not Change

Comparing Two Strings

Appending Strings

Extracting Parts of a String

Searching in a String

InStr

InStrRev

Removing Blanks

The Use and Examples

Length of a String

Reversing a String

Comparing Strings

Comparing Strings Using Pattern Matching

Replacing Part of a String

Multiple Replaces

Chapter Six: Error Handling and Debugging

The On Error Statement

Enabled and Active Error Handlers

The Resume Statement

Error Handling With Multiple Procedures

A Note of Caution

Chapter Seven: Mistakes to Avoid

Not Using Arrays

Using .Select or .Activate

Using Variant Type

Not Using Application.ScreenUpdating = False

Referencing the Worksheet Name with a String

Not Qualifying the Range References

Writing a Big Function

Using Nested For or If Statements

Conclusion

Sources

Introduction

Thank you for purchasing the book, ‘Excel VBA - Intermediate Lessons in Excel VBA Programming for Professional Advancement.’

Excel VBA is an extremely helpful way to automate a routine task like copying data, creating your functions to reduce manual effort and increase productivity. When you use VBA, you can manipulate and customize data that is present in an Excel sheet. If you have read my previous book, you will have gathered some information on what VBA is. You would have learned about the different variables in VBA and data types, and how you can use them.

In this book, we will go one step further and focus on some important aspects of VBA. When you use VBA in Excel, you must also learn how to source data from one workbook to another without having to open the file. You also need to know more about working with loops and conditional statements. These statements make it easier to simplify iterative tasks. If you are eager to learn more about these aspects of VBA, you have come to the right place. Along with the points mentioned above, you will also learn about how you can manipulate strings and handle errors.

There are many examples given across the book that will help you understand the concepts better. Practice these examples before you begin to write your own code. You must remember that practice will make you a better programmer.

I hope you will find all the information you were looking for.

Chapter One: