Programming in Visual Basic (VB): For Visual Studio
()
About this ebook
The book may not contain everything you should know about programming in VB, 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 VB with concrete examples of programs.
To see the programs inserted in this document in Excel VBA, I refer you to my other eBook "PROGRAMMING IN VBA".
Read more from Olga Maria Stefania Cucaro
HTML, CSS, Bootstrap, Php, Javascript and MySql: All you need to know to create a dynamic site Rating: 4 out of 5 stars4/5Pivot Tables for everyone. From simple tables to Power-Pivot: Useful guide for creating Pivot Tables in Excel Rating: 0 out of 5 stars0 ratingsTales and Imaginary Stories Rating: 0 out of 5 stars0 ratingsThe Value of Intangible Assets and the Human Capital Disclosure of companies specializing in IT Rating: 0 out of 5 stars0 ratingsThe bankruptcy prediction model Z-ScoreM for Italian Manufacturing Listed Companies and Z'-ScoreM for Italian Industrial Company Rating: 0 out of 5 stars0 ratingsDisclosure on sustainable development, CSR environmental disclosure and greater value recognized to the company by users Rating: 0 out of 5 stars0 ratingsGaia the Princess and the Magic Bracelet Rating: 0 out of 5 stars0 ratings
Related to Programming in Visual Basic (VB)
Related ebooks
From VBA to VSTO: Is Excel's New Engine Right for You? Rating: 0 out of 5 stars0 ratingsExcel VBA: A Beginners' Guide Rating: 4 out of 5 stars4/5Visual Basic 6.0 Programming By Examples: 7 Windows Application Examples Rating: 3 out of 5 stars3/5Programming Concepts in C++ Rating: 0 out of 5 stars0 ratingsExcel VBA 24-Hour Trainer Rating: 3 out of 5 stars3/5Excel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsExcel 2007 VBA Programmer's Reference Rating: 5 out of 5 stars5/5Learn VBScript in 24 Hours Rating: 0 out of 5 stars0 ratingsExcel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch: 1 Rating: 4 out of 5 stars4/5Start-to-Finish Visual Basic 2015 Rating: 5 out of 5 stars5/5Excel VBA Recipes Rating: 4 out of 5 stars4/5Start-to-Finish Visual C# 2015 Rating: 5 out of 5 stars5/5Excel Programming with VBA Starter Rating: 0 out of 5 stars0 ratingsVBA for Excel: Programming VBA Macros - The Easy Introduction for Beginners and Non-Programmers Rating: 3 out of 5 stars3/5Visual Studio Code: End-to-End Editing and Debugging Tools for Web Developers Rating: 0 out of 5 stars0 ratingsSecrets of MS Excel VBA Macros for Beginners !: Save Your Time With Visual Basic Macros! Rating: 4 out of 5 stars4/5JavaScript for Gurus: Use JavaScript programming features, techniques and modules to solve everyday problems Rating: 0 out of 5 stars0 ratingsLearn R By Coding Rating: 0 out of 5 stars0 ratingsLearn WPF MVVM - XAML, C# and the MVVM pattern Rating: 4 out of 5 stars4/5Excel 2019 Power Programming with VBA Rating: 5 out of 5 stars5/5Ms Access 2007: Step by Step Rating: 5 out of 5 stars5/5Excel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratingsJavaScript: Best Practices to Programming Code with JavaScript: JavaScript Computer Programming, #3 Rating: 0 out of 5 stars0 ratingsUseful Python Rating: 0 out of 5 stars0 ratingsVisual Basic 2010 Coding Briefs Data Access Rating: 5 out of 5 stars5/5Visual Basic for the Approved Workman Rating: 0 out of 5 stars0 ratingsExcel VBA Macro Programming Rating: 0 out of 5 stars0 ratings
Programming For You
Python: Learn Python in 24 Hours Rating: 4 out of 5 stars4/5Python: For Beginners A Crash Course Guide To Learn Python in 1 Week Rating: 4 out of 5 stars4/5Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Coding All-in-One For Dummies Rating: 4 out of 5 stars4/5Python Programming : How to Code Python Fast In Just 24 Hours With 7 Simple Steps Rating: 4 out of 5 stars4/5SQL: For Beginners: Your Guide To Easily Learn SQL Programming in 7 Days Rating: 5 out of 5 stars5/5Java for Beginners: A Crash Course to Learn Java Programming in 1 Week Rating: 5 out of 5 stars5/5HTML & CSS: Learn the Fundaments in 7 Days Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Python QuickStart Guide: The Simplified Beginner's Guide to Python Programming Using Hands-On Projects and Real-World Applications Rating: 0 out of 5 stars0 ratingsPYTHON: Practical Python Programming For Beginners & Experts With Hands-on Project Rating: 5 out of 5 stars5/5C All-in-One Desk Reference For Dummies Rating: 5 out of 5 stars5/5SQL All-in-One For Dummies Rating: 3 out of 5 stars3/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5TensorFlow in 1 Day: Make your own Neural Network Rating: 4 out of 5 stars4/5Python for Beginners: Learn the Fundamentals of Computer Programming Rating: 0 out of 5 stars0 ratingsC# 7.0 All-in-One For Dummies Rating: 0 out of 5 stars0 ratingsLearn PowerShell in a Month of Lunches, Fourth Edition: Covers Windows, Linux, and macOS Rating: 0 out of 5 stars0 ratingsC++ Learn in 24 Hours Rating: 0 out of 5 stars0 ratingsLearn SQL in 24 Hours Rating: 5 out of 5 stars5/5Narrative Design for Indies: Getting Started Rating: 4 out of 5 stars4/5
Reviews for Programming in Visual Basic (VB)
0 ratings0 reviews
Book preview
Programming in Visual Basic (VB) - Olga Maria Stefania Cucaro
Introduction
This work was born from the necessity 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 and in the Visual Studio VB. This document is intended to introduce users to programming in general and to programming in Visual Basic in particular. The VB is simple and can be used on existing csv files or data entered directly into Visual Studio, quickly processing a large amount of data. For the moment the only tool we need is Visual Studio and the csv files. Of course, I can't go into the intricacies of the databases that I will definitely include in a future book.
The book may not contain everything you should know about programming in VB, 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 VB with concrete examples of programs.
To see the programs inserted in this document in Excel VBA, I refer you to my other eBook PROGRAMMING IN VBA
.
Summary
Introduction 1
Summary 2
PART I.: The basics of programming 4
Chapter 1: Understanding and solving problems 5
Understanding a problem and breaking it down into simple operations 5
Identify variables and constants 6
What does pseudo-code mean 6
Chapter 2: The logic of programming 7
The variables 7
The conditions 8
The cycles 9
Transform a sequence of operations into instructions 10
The flow chart 11
13
PART II: Programming in VB 15
Chapter 3: The VB 16
What is VB and how to use it 16
How to access VB 16
Chapter 4: Program in VB 21
The variables in VB 21
Chapter 5: Examples of programming in VB 23
The sum of two numbers 23
The sum of n numbers 26
The average of n numbers 29
Count values 34
Sum of the values in a given range 38
Sum of values that meet certain conditions 44
Chapter 6: Use of multiple sheets to solve complex work problems 51
COUNT CONTACTS 51
REMUNERATION CALCULATION 64
Chapter 7: How to use databases 87
Example of DIRECTORY with a table created in Access 87
Chapter 8: Using some APIs already present in Windows 112
Memory management 112
Chapter 9: Publish the application 117
123
Epilogue / Conclusion 124
PART I.: The basics of programming
Chapter 1: Understanding and solving problems
Understanding a problem and breaking it down into simple operations
The first step before programming is to understand the problem to be solved with the program we are going to create.
Just like in math, it is best to think carefully before starting to solve the problem. For example, let's assume we work in a Call Center and have all the