Im 443 Exam 1 Flash Cards

Front 1

difference between VBA and a Macro?

Back 1

macro = computer program that gives automated instructions to the computer (original meaning); Excel meaning: a program that users can write by themselves.
VBA = general purpose language used to write programs (macros) that is independent of the application.
Because VBA works with an object model, it doesn't need any special access to the internals of Excel.
VBA programs (macros) can control any application that provides an object model

Front 2

what is .NET?

Back 2

The Microsoft .NET Framework is a software framework that can be installed on computers running Microsoft Windows operating systems. It includes a large library of coded solutions to common programming problems and a virtual machine that manages the execution of programs written specifically for the framework. The .NET Framework is a Microsoft offering and is intended to be used by most new applications created for the Windows platform.

Front 3

macro naming scheme?

Back 3

must begin with a letter; can contain upper & lower case letters, numbers, & underscores. but no spaces or other special characters

Front 4

to learn more about format strings?

Back 4

type "number format codes" in excel help search

Front 5

how to show the developer tab?

Back 5

Excel Options dialog box, on the Popular page

Front 6

rule for assigning shortcut keys?

Back 6

if you assign a built-in shortcut key to your macro then using the shortcut will run your macro rather than the built-in command. it is best to avoid this. using Ctrl+Shift key combinations is a good approach.

Front 7

macro-free workbooks extension?

Back 7

.xlsx

Front 8

macro-enabled workbook extension?

Back 8

.xlsm

Front 9

ways to run a macro?

Back 9

From VB editor: F5 or the Run Sub/UserForm button in the toolbar
From workbook: View tab-> Macro->select and run (or shortcut keys or custom bottom on Quick Access Toolbar or activeX control)

Front 10

how to recognize an object in code?

Back 10

will be a word followed by a period

Front 11

syntax difference between specifying an argument and assigning a value to a property?

Back 11

to specify an argument, use the argumentName:=value;
to assign a value to a property, use propertyName = value
in the latter there is a space before and after =; in the former, the name and := are optional

Front 12

how to create a trusted location?

Back 12

Excel Options-> trust center -> trusted locations
-> add a new location

Front 13

where to add the digital signature?

Back 13

if you sign from the Excel
menu-> Prepare then it prevent changes to the cells.
if you sign from VB Editor, it will prevents changes to the macros

Front 14

to delete a digital ID?

Back 14

Internet Options from Control Panel, on Content tab, click Certificates

Front 15

can you edit statements while stepping through a macro?

Back 15

yes, but not all. VB will warn you if you attempt to make a change that would require you to restart the macro

Front 16

how get a filename from a user?

Back 16

Application.GetOpenFileName()

Front 17

how to record a macro with relative cell references?

Back 17

View tab of ribbon -> Macros ->
Use Relative References

Front 18

make macro operate quietly?

Back 18

Application.DisplayAlerts = False

Front 19

3 ways to refer to an open workbook?

Back 19

by name, by position, or by pointing

Front 20

what is a class?

Back 20

a type of object (all objects in a particular class have the same properties & methods available)

Front 21

what is a collection?

Back 21

it is an object that is a collection or group of other objects; the collection "Students" is a group of "Student" objects.

Front 22

VBA name for the combined list of properties and methods of an object?

Back 22

members

Front 23

ways to open the VB editor?

Back 23

editing a macro, view code command on shortcut menu for any worksheet, Visual Basic button on developer tab, Alt+F11

Front 24

how to prevent a dockable window from docking when you move it?

Back 24

hold down Ctrl while you move the window around

Front 25

2 different syntax for referring to an item in a collection?

Back 25

workbooks.item(1).xxx
or
workbooks(1).xxx

Front 26

what is a global property (and give an example)?

Back 26

global property is a property that is not preceded by an object;
example- Workbooks has two meanings in Excel: it is the name of an object class; and the name of a global property that that establishes a reference to the collection of open workbooks

Front 27

how to close a workbook without excel prompting to save changes?

Back 27

change the Saved property of the Workbook object to True

Front 28

function that allows you to treat multiple values as one?

Back 28

Array
example: Worksheets(Array(1,3,5)). Select will select the 1st, 3rd & 5th sheets

Front 29

how to make Auto Lists show for variables?

Back 29

declare the variable as specific object

example:
Dim mySheet as Worksheet

then mySheet. will cause Auto List to show (listing members of the Worksheet object class)

Front 30

do methods return values?

Back 30

yes, some do.
example Worksheet.Delete will return True/False depending if the sheet was actually deleted
also, Collection.Add will usually return a reference to the new item that was created.

Front 31

what is the <global> object class?

Back 31

not a real object class; it includes all methods & properties you can use without specifying an object; these members can start a statement

Front 32

what is the Range property?

Back 32

a member of the <global> object class, it returns a reference to a Range object; (it is a very flexible way to establish a link to a Range object)

Front 33

in the immediate window, how do you display the value of an expression?

Back 33

type ?Expression to return the value of Expression

Front 34

what is the Cells property?

Back 34

a member of the <global> object class, it returns a collection of cells & its result is a Range object. example: Cells(1).Select selections the cell A1. unlike other collections, it allows you to specify an item by using both row & column values. example: Cells(3,2).Select selects the cell B3.

Front 35

what are the Rows and Columns properties?

Back 35

members of <global> object class, they return a collection or rows/columns; they result in Range objects. note: only to specify a range of rows/columns is by name. example Columns("A:H").Select or Rows("2:7").Select

Front 36

keyboard shortcut to display the Auto List

Back 36

Ctrl + Space

Front 37

describe the CurrentRegion property

Back 37

member of Range object class; it returns a rectangular range that includes the range and is surrounded by either blank cells or the edge of the worksheet

Front 38

why doesn't the Selection property display the Auto List?

Back 38

the Selection property can return more objects of different classes depending on what is selected, so the Auto List function would not know which member list to display

Front 39

difference between Range property of <global> and Range property of Range object class

Back 39

they both behave the same way, except that Range property of Range object behaves relative to the Range object
this is the same difference between Rows <global> property and Rows property of Range object (same for Cells and Columns too)

Front 40

R1C1 reference style: what does =R5C[2] mean?

Back 40

= value of cell two columns to the right, in row 5.