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 ratingsThe bankruptcy prediction model Z-ScoreM for Italian Manufacturing Listed Companies and Z'-ScoreM for Italian Industrial Company Rating: 0 out of 5 stars0 ratingsLooking at China - COVID-19 in Italy -: FORECASTS BASED ON OFFICIAL DATA ON CORONAVIRUS Rating: 0 out of 5 stars0 ratingsAll crazy about the Mona Lisa: The image of the Mona Lisa from corporate communication to the product 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 ratingsVisual Basic 6.0 Programming By Examples: 7 Windows Application Examples Rating: 3 out of 5 stars3/5Learn VBScript in 24 Hours Rating: 0 out of 5 stars0 ratingsASP.NET and VB.NET in 30 Days: Acquire a Solid Foundation in the Fundamentals of Windows and Web Application Development Rating: 0 out of 5 stars0 ratingsProgramming PowerPoint With VBA Straight to the Point Rating: 0 out of 5 stars0 ratingsExcel VBA: A Beginners' Guide Rating: 4 out of 5 stars4/5Mastering VBA for Microsoft Office 365 Rating: 5 out of 5 stars5/5Start-to-Finish Visual Basic 2015 Rating: 5 out of 5 stars5/5Excel Macros - A Step-by-Step Illustrated Guide to Learn Excel Macros 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/5Excel VBA Recipes Rating: 4 out of 5 stars4/5Visual Studio Code: End-to-End Editing and Debugging Tools for Web Developers Rating: 0 out of 5 stars0 ratingsExcel 2007 VBA Programmer's Reference Rating: 5 out of 5 stars5/5JavaScript for Gurus: Use JavaScript programming features, techniques and modules to solve everyday problems Rating: 0 out of 5 stars0 ratingsLearn Programming Using C# 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/5Excel VBA: A Step-By-Step Tutorial For Beginners To Learn Excel VBA Programming From Scratch: 1 Rating: 4 out of 5 stars4/5Excel Programming with VBA Starter Rating: 0 out of 5 stars0 ratingsExcel 2019 Power Programming with VBA Rating: 5 out of 5 stars5/5COBOL Rating: 0 out of 5 stars0 ratingsExcel : The Complete Ultimate Comprehensive Step-By-Step Guide To Learn Excel Programming Rating: 0 out of 5 stars0 ratingsExcel VBA Programming: Automating Excel through Visual Basic for Application Rating: 0 out of 5 stars0 ratingsAccess Essentials 2019 Rating: 0 out of 5 stars0 ratingswxPython Application Development Cookbook Rating: 0 out of 5 stars0 ratingsUseful Python Rating: 0 out of 5 stars0 ratingsVisual Studio Code Distilled: Evolved Code Editing for Windows, macOS, and Linux Rating: 3 out of 5 stars3/5JavaScript: Best Practices to Programming Code with JavaScript: JavaScript Computer Programming, #3 Rating: 0 out of 5 stars0 ratingsVisual Basic .NET for complete beginners Rating: 5 out of 5 stars5/5
Programming For You
Excel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Learn PowerShell in a Month of Lunches, Fourth Edition: Covers Windows, Linux, and macOS Rating: 5 out of 5 stars5/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5Excel 101: A Beginner's & Intermediate's Guide for Mastering the Quintessence of Microsoft Excel (2010-2019 & 365) in no time! Rating: 0 out of 5 stars0 ratingsPython Programming : How to Code Python Fast In Just 24 Hours With 7 Simple Steps Rating: 4 out of 5 stars4/5Coding All-in-One For Dummies Rating: 4 out of 5 stars4/5HTML in 30 Pages Rating: 5 out of 5 stars5/5C# Programming from Zero to Proficiency (Beginner): C# from Zero to Proficiency, #2 Rating: 0 out of 5 stars0 ratingsC Programming For Beginners: The Simple Guide to Learning C Programming Language Fast! Rating: 5 out of 5 stars5/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 ratingsSQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5HTML & CSS: Learn the Fundaments in 7 Days Rating: 4 out of 5 stars4/5Linux: Learn in 24 Hours Rating: 5 out of 5 stars5/5Python: Learn Python in 24 Hours Rating: 4 out of 5 stars4/5Spies, Lies, and Algorithms: The History and Future of American Intelligence Rating: 4 out of 5 stars4/5Visual Studio Code: End-to-End Editing and Debugging Tools for Web Developers Rating: 0 out of 5 stars0 ratingsBeginning Programming with Python For Dummies Rating: 3 out of 5 stars3/5C Programming for Beginners: Your Guide to Easily Learn C Programming In 7 Days Rating: 4 out of 5 stars4/5Programming Arduino: Getting Started with Sketches 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