From the course: Excel: Learning VBA
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Introduce object-oriented programming - Microsoft Excel Tutorial
From the course: Excel: Learning VBA
Introduce object-oriented programming
- [Instructor] If we're going to talk about Visual Basic for Applications, which is a programming language, we need to discuss what exactly a programming language is. For our purposes, a programming language is a system of statements used to control a computer. If you are a computer scientist, there are many ways that you could argue about this definition, but I believe that this one, for our purposes, is exactly what we need. Any programming language must meet several requirements for it to be an effective way to control your computer. First, you have to be able to accept input. That could be through the user interface, such as a keyboard or from a file that you read data in from. You must be able to store data to be able to work with it, and you must be able to manipulate that data that is make changes to it, for example, by performing calculations. And, finally, produce output. That can be to the screen, it can be to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Introduce object-oriented programming3m 2s
-
(Locked)
Examine the Excel object model4m 14s
-
(Locked)
Work in the Visual Basic Editor6m 27s
-
(Locked)
Set VBA project properties4m 28s
-
(Locked)
Create, export, and delete code modules5m 54s
-
(Locked)
Create a subroutine3m 28s
-
Create a function5m 2s
-
(Locked)
Add comments to your code4m 47s
-
Run a VBA procedure5m 20s
-
(Locked)
Add code to a recorded macro3m 48s
-
(Locked)
-
-
-
-
-
-
-