ACCOUNTING 2258 Exam
Macro - CORRECT ANSWER-Series of commands, actions, and functions that can be stored
and initiated whenever you ant to perform a task.
What language is Macro written in? - CORRECT ANSWER-Visual Basic
Visual Basic for Applications (VBA) - CORRECT ANSWER-programming language.
Visual Basic Editor (VBE) - CORRECT ANSWER-Accessed through Developer tab. Where all
macros created in Excel are stored; new macros can be created, and previously created macros
can be edited or deleted.
Visual Basic Commands - CORRECT ANSWER-steps of the macro that define the macro's
functionality.
"macro code"
- Automate and control input (efficiency and accuracy)
- Guide suers through a spreadsheet (efficiency and accuracy)
3 methods for creating a macro - CORRECT ANSWER-1. Use the macro recorder to record a
new macro.
2. Write a new macro from scratch in VBE
3. C&P and customize prev. created macro.
Code Window - CORRECT ANSWER-window in VBE
What color are comments? - CORRECT ANSWER-Green
How do you start a comment? - CORRECT ANSWER-an apostrophe ( 'comment)
What does a comment do? - CORRECT ANSWER-IN visual basic code to help clarify purpose
and meaning of the macro without affecting the actual execution of the macro.
Local Window - CORRECT ANSWER-displays variables and how they change as a macro is
run.
*Useful in debugging a macro. Accessed under View menu in VBE.
What is a Method? - CORRECT ANSWER-An action that can be performed on an object.
(such as clearcontents, copy, delete, select, save, close, etc.)
, VBC syntax for methods - CORRECT ANSWER-object.method(parameter value)
*parameter value = optional
What is a Module? - CORRECT ANSWER-collection of macros located in the Visual Basic
Editor.
Where can modules be renamed? - CORRECT ANSWER-In the Properties Window.
What is an Object? - CORRECT ANSWER-an element of the Excel Application (such as a
worksheet, a cell, a range of cells, or the entire workbook)
Code to manipulate an object.
VBC for objects - CORRECT ANSWER-object.property
or
object.method
What is the object and what is the method in this code?
Range("A3").Select - CORRECT ANSWER-Cell A3 is the Object.
Select is the Method.
Property Explorer Window - CORRECT ANSWER-located on the left side of VBE. Where to
access macros.
What is a property? - CORRECT ANSWER-an attribute of an object in Excel that
defines/changes one of its characteristics (such as its name, size, color, formula, value, or
location).
Property Syntax - CORRECT ANSWER-object.property=expression.
Range ("A3").Font.ColorIndex=3
Syntax - CORRECT ANSWER-set of rules specifying how you ender Visual Basic commands.
What is a variable? - CORRECT ANSWER-named storage location in the VBE that contains
data you can retrieve and modify while the macro code is being executed.
What is relative referencing? - CORRECT ANSWER-A cell references that changes based on
cell location.
General Syntax for selecting a cell using relative referencing: - CORRECT
ANSWER-ActiveCell.Select
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller denicetho. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.88. You're not tied to anything after your purchase.