Khan, Arshad

Business Intelligence and Data Analysis in the Age of AI

Campesato, Oswald

Beginning Python 3 with Claude 3

Fortino, Andres

Case Studies in Excel, R, and ChatGPT

Data Analysis for Business Decisions

Zherlitsyn, Dmytro

Financial Data Analysis Using Python

A Prompt-based Exploration of LLMs

Large Language Models for Developers

Beginning Python 3 with Grok 2

Herman, Erik

Using Analytics and Case Studies

Data Science for Decision Makers

Goralski, Walter

Understanding AI, IoT, 6G and The Infrastructure Revolution

Erik, Herman L.

Theory, Applications and Ethics

AI Revealed

CAMPESATO, OSWALD

CSS3 and SVG with Meta AI

Pocket Primer

Microsoft Excel 2021 Programming Pocket Primer

Chapter 8 Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections

Frontmatter

Contents

Acknowledgments

Introduction

Chapter 1 Excel Macros: A Quick Start in Excel VBA Programming

Chapter 2 Excel Programming Environment: A Quick Overview of its Tools and Features (VBE)

Chapter 3 Excel VBA Fundamentals: A Quick Reference to Writing VBA Code

Chapter 4 Excel VBA Procedures: A Quick Guide to Writing Function Procedures

Chapter 5 Adding Decisions to Excel VBA Programs: A Quick Introduction to Conditional Statements

Chapter 6 Adding Repeating Actions to Excel VBA Programs: A Quick Introduction to Looping Statements

Chapter 7 Storing Multiple Values in Excel VBA Programs: A Quick Introduction to Working with Arrays

Chapter 9 Excel Tools for Testing and Debugging: A Quick Introduction to Testing VBA Programs

Index

Korol, Julitta

As part of the successful Pocket Primer series, this book was designed for someone like you who needs to master Excel programming fundamentals without spending too much time. All you need is a short book to get you started. It will show you only the things you need to know to feel at home with VBA. What you learn in this book on Excel programming will also apply to, say, Access programming. The book is divided into nine chapters that progressively introduce you to programming Microsoft Excel 2021.

As part of the successful Pocket Primer series, this book was designed for someone like you who needs to master Excel programming fundamentals without...

Chapter 8 Keeping Track of Multiple Values in Excel VBA...

Chapter 8 Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections

Format

Chapter 8 Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections

Julitta Korol

People Also Read