Excel

Question 1

what is application scripting?

Answer 1

a way to automate lengthy manual procedures, customize and extend an application, and create a different interface.

Question 2

what does it mean to record a script?

Answer 2

to record a manual procedure and play it back many times.

Question 3

What are 4 reasons you would edit a script?

Answer 3

1. make it more general
2. eliminate unnecessary steps
3. to wrap a loop around it
4. to do something similar.

Question 4

what do the characters ‘ and _ mean in a script?

Answer 4

’: comment
_: the statement continues to the next line.

Question 5

what is a subroutine?

Answer 5

a script that does something, but doesnt return a value.

Question 6

what does a function do?

Answer 6

returns a value

Question 7

what are the data objects in excel Marcos and give 5 examples.

Answer 7

everything you see in a workbook; everything except the application.
1. workbook
2. worksheets
3. cells
4. charts
5. ranges

Question 8

what are 3 examples properties?

Answer 8

colour, value and font.

Question 9

what are 2 characteristics of properties?

Answer 9

1. can be read or set in macros
2. can be another object

Question 10

what are 3 examples of methods?

Answer 10

ClearContents, Sort and Worksheet

Question 11

what are 2 characteristics of methods?

Answer 11

1. they do something to an object.
2. they contain parameters

Question 12

what are methods?

Answer 12

a type of built-in function or subroutine that does something with or to an object.

Question 13

what is a member?

Answer 13

both a property and a method.

Question 14

what is a benefit of naming ranges/cells?

Answer 14

by adding a blank row at the end of a named range, a macro will include any columns or rows added to the range.

Question 15

what is $A$3 an example of?

Answer 15

an absolute reference.

Question 16

when is a breakpoint used?

Answer 16

in debugging

Question 17

what does a breakpoint do and how do you set it?

Answer 17

stops the macro when it gets to a specific line so you can parse the code line by line, you can set by clicking on the left margin.

Question 18

Where are macros stored?

Answer 18

in modules

Question 19

in the following script, what are the objects, methods and properties?
Application.Worksheets(“Visa”) _
.Range(“Stmt”).Font.Name = “Helvetica”

Answer 19

Object: Application
Methods: Worksheets(): returns a Worksheet object (goes to a worksheet), Range(): returns a Range object
Properties: Font: value is a Font object, Name: a string