This book is part three of a three-part course for people who want to learn VBA fast. It completes the step-by-step course in VBA function design and explores how to take VBA further, for both function and macro design. It aims to leave readers confident in what they have learned and in how to learn more.
Exercises are included to help readers get started with macro design by adapting what they know about functions. Techniques for designing and managing code are reviewed. Examples, practice exercises, and explanations are provided at each stage, as in the rest of the series. Learn VBA by using it. See, do, review, and then build on what you learned in books one and two.
Why learn VBA?
VBA allows you to automate repetitive tasks when using Microsoft Office packages like Word and Excel.
VBA also allows you to make your own functions in Excel. These can replace what you do with formulae, and do more besides.
What’s the simplest way to continue learning VBA?
Complete the course! Practice using core VBA components by designing your own VBA functions in structured exercises, and start learning how these can be applied to macros.
Why should I buy this book?
This book continues to introduce VBA step-by-step, building on the content of book two. Examples, explanations and practice exercises are provided at each stage. All practice exercises have hyperlinked answers, so you can ‘flip’ the page from problem to solution and back, with ease. See, understand and then practice new concepts. Learn how to use them together, and how they fit into the bigger picture. This book will help you:
- use loops to process data from cell ranges
- use macros to alter data in cell ranges
- design your own windows to control your macros
- use arrays to process lists of values
- process decisions more complicated than ‘if...then...else’
- review how you design programs
- decide what to do next
This book is the last of three in a course. Learn more VBA today.
Buy 'Learn VBA Fast, Vol. 3' today and find out how easy it can be.
Exercises are included to help readers get started with macro design by adapting what they know about functions. Techniques for designing and managing code are reviewed. Examples, practice exercises, and explanations are provided at each stage, as in the rest of the series. Learn VBA by using it. See, do, review, and then build on what you learned in books one and two.
Why learn VBA?
VBA allows you to automate repetitive tasks when using Microsoft Office packages like Word and Excel.
VBA also allows you to make your own functions in Excel. These can replace what you do with formulae, and do more besides.
What’s the simplest way to continue learning VBA?
Complete the course! Practice using core VBA components by designing your own VBA functions in structured exercises, and start learning how these can be applied to macros.
Why should I buy this book?
This book continues to introduce VBA step-by-step, building on the content of book two. Examples, explanations and practice exercises are provided at each stage. All practice exercises have hyperlinked answers, so you can ‘flip’ the page from problem to solution and back, with ease. See, understand and then practice new concepts. Learn how to use them together, and how they fit into the bigger picture. This book will help you:
- use loops to process data from cell ranges
- use macros to alter data in cell ranges
- design your own windows to control your macros
- use arrays to process lists of values
- process decisions more complicated than ‘if...then...else’
- review how you design programs
- decide what to do next
This book is the last of three in a course. Learn more VBA today.
Buy 'Learn VBA Fast, Vol. 3' today and find out how easy it can be.
