10,99 €
This work was born from the need found by the author to solve various problems repeated over time, concerning the data inserted in Excel sheets in the shortest possible time. The author, being a programmer and expert in Pascal, Cobol and Javascript, searched for the most suitable solution and found it in the Excel VBA. This document is intended to introduce users to programming in general and to programming in Visual Basic for Applications of Excel in particular. VBA is simple and can be used on existing Excel files, quickly processing a large amount of data. The only tool we need is Excel.
The book may not contain everything you should know about programming in VBA, but it does point the finger at the key points to create some programs which are explained in detail in the various chapters. The content is divided into two parts, one which explains programming in general and the second which explains programming in VBA with concrete examples of programs.
Das E-Book können Sie in Legimi-Apps oder einer beliebigen App lesen, die das folgende Format unterstützen:
EASY PROGRAMMING IN VBA
Summary
Introduction
PART I.: The basics of programming
Chapter 1: Understanding and solving problems
Understanding a problem and breaking it down into simple operations
Identify variables and constants
What does pseudo-code mean
Chapter 2: The logic of programming
The variables
Transform a sequence of operations into instructions
The flow chart
PART II: Programming in VBA
Chapter 3: The VBA
What is VBA and what can it do?
How to access VBA
Chapter 4: Program in VBA
Variables in Excel sheets
Macros in Excel
Create a button to activate a macro
Chapter 5: Examples of programming in VBA
The sum of n numbers
The average of n numbers
Count values
Sum of the values in a given range
Sum of values that meet certain conditions
Use of multiple sheets to solve complex work problems
Epilogue / Conclusion
OF EXCEL
FROM THE ANALYSIS OF THE PROBLEM TO THE PROGRAM IN VBA
FROM THE SIMPLE TO THE MOST COMPLEX PROGRAMS
Of
OLGA MARIA STEFANIA CUCARO
© Copyright 2021 by Olga Maria Stefania Cucaro - All rights reserved.
It is not permitted to reproduce, duplicate or send any part of this document electronically or in print. Copying of this document is strictly prohibited. All the programs included in this book are also copyrighted by the author / creator of the work.
Dedicated to:
To my mother who has always believed in me and to my IT professors who made my working life easier
Summary iv
Introduction 1
PART I.: The basics of programming 2
Chapter 1: Understanding and solving problems 3
Understanding a problem and breaking it down into simple operations 3
Identify variables and constants 4
What does pseudo-code mean 4
Chapter 2: The logic of programming 5
The variables 5
The conditions 6
The cycles 7
Transform a sequence of operations into instructions 8
The flow chart 9
11
PART II: Programming in VBA 13
Chapter 3: The VBA 14
What is VBA and what can it do? 14
How to access VBA 14
Chapter 4: Program in VBA 16
Variables in Excel sheets 16
Macros in Excel 17
Create a button to activate a macro 18
Chapter 5: Examples of programming in VBA 20
The sum of n numbers 20
The average of n numbers 23
Count values 27
Sum of the values in a given range 31
Sum of values that meet certain conditions 37
Use of multiple sheets to solve complex work problems 41
Epilogue / Conclusion 53
This work was born from the necessity found by the author to solve problems of various kinds during her studies and work. The large amount of data and the repetitive processing required an automated procedure that could be applied in any context. The author, being a programmer and being an expert in Pascal, Cobol and Javascript, searched for the most suitable solution and found it in the Excel VBA. This document is intended to introduce users to programming in general and to programming in Visual Basic for Applications and Excel in particular. VBA is simple and can be used on existing Excel files, quickly processing a large amount of data. The only tool we need is Excel.