This class was created by Brainscape user Ben McMahon. Visit their profile to learn more about the creator.
By:
Ben McMahon
- decks
- flashcards
- learners
Decks in this class (11)
Lesson#1 What are Macros?
What is a macro,
What are the 2 types of procedure,
What is a sub procedure
6
cards
Lesson#2 VBA Statements
What are the 5 basic elements of ...,
What is an object,
What are collections
8
cards
Lesson#3 Objects and the Excel Object Model
What is the excel object model,
Which object is at the top of the...,
What are the 3 basic steps to nav...
6
cards
Lesson#4 Properties, Methods and Parameters
What are properties,
What are methods,
What 2 things can you do when wor...
13
cards
Lesson#5 Excel Cell Referencing
How do you normally refer cells i...,
What is an alternate way of refer...,
What type of r1c1 reference do yo...
7
cards
Lesson# 6 Expressions and Operators
What 2 things can you use express...,
What are the 5 operator categories,
What do you use arithmetic operat...
11
cards
Lesson#7 Variables and Data Types
What is a variable,
What two fields can you specify w...,
After creating a variable how can...
27
cards
Lesson#8 Object Variables
What difference does the data typ...,
What is the statement for assigni...
2
cards
Lesson#9 Call Procedures and Pass Data Between Procedures
What are the 2 separate procedure...,
What are the 3 different ways to ...,
What does procedure scope refer to
16
cards
Lesson#10 Functions in VBA
What are the 3 types of functions...,
How do you use a vba built in fun...,
What types of arguments can you u...
14
cards
Lesson#11 Control Code Execution and Conditional Execution of Statements
What is the goto statement,
What is the basic statement struc...,
How do you distinguish between nu...
12
cards
More about
VBA Basics
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Ben McMahon's VBA Basics flashcards now!
How studying works.
Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.
Add your own flashcards.
Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!
What's Brainscape anyway?
Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.
We use an adaptive study algorithm that is proven to help you learn faster and remember longer....
Looking for something else?
Basic German Vocabulary
- 34 decks
- 4722 flashcards
- 69 learners
Decks:
18 Aufforderungen Konflikten, 17 Gefuhle Stimmungen Meinungen, 16 Amt Behorde Gesellschaft, And more!
VBA
- 5 decks
- 59 flashcards
- 2 learners
Decks:
10 Introduction, 20 Subs Functions Decisions Flowcharts, 30 Record Macro Functions Debugging And, And more!
Human basic neuroscience
- 68 decks
- 4351 flashcards
- 129 learners
Decks:
Anatomy Of The Nervous System, Development Of The Brain, The Structure And Development Of The Ner, And more!
