April 2006
Beginner
1114 pages
98h 16m
English
Content preview from Programming Excel with VBA and .NETBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Parts of a Program
A program is made up of the basic parts shown in Figure 2-1.
- Project
Is the workbook where the program is stored. Each workbook has one Visual Basic project.
- Classes and modules
Store the code associated with the workbook and the sheets the workbook contains. Classes and modules help organize the procedures in your program.
- Procedures
Perform the program’s work. You can’t do anything in Visual Basic without creating at least one procedure.
Figure 2-1. The main parts of a program
- Variables
Store values used by your program.
- Conditional statements
Make decisions within procedures.
- Loops
Repeat actions. Together, conditional statements and loops form the logic that your procedure uses to accomplish its task.
- Expressions
Evaluate a combination of items to return a single result. Expressions are the smallest unit of work in a program and they usually involve operators such as
+,-,*, or&(combine strings).
The following sections describe these parts in detail. If you are new to programming, I recommend that you follow along with the samples carefully. I take a top-down approach and I’ve tried to be clear about how, when, and why you use each part.
If you’re an experienced programmer, the top-down organization of this chapter should work well for you as a reference. If you think you know this already, I recommend that you read the sections "Classes and Modules,” ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.