Page 88 - Excel Progamming Weekend Crash Course

e540629 PR01.qxd 9/2/03 9:28 AM Page 63

PA
PA R T
R
T

#
I
I

Friday Evening

Part Review

1. What is a program?
2. How do you start the VBA Editor from Excel?
3. How do you insert a new code module in a VBA project?
4. What’s the easiest way to copy code from one VBA project to another?
5. What is a property?
6. How do you create an absolute cell reference?
7. How do object properties and methods differ?
8. Must a method call always include arguments in the precise order as defined for
the method?
9. Which VBA statement is used to loop through all the members of a collection?
10. In a VBA program running in Excel, when is it necessary to use the Application
keyword?
11. How would you save a copy of a workbook under a new name without changing
the original workbook’s name?
12. What method is used to print the current workbook?
13. How do you obtain a reference to the active worksheet in a workbook?
14. How do you change a worksheet’s name in code (the name that displays on the
worksheet’s tab)?
15. How can you prevent Excel from displaying its confirmation dialog box when you
delete a worksheet in code?
16. What is the Nothing keyword used for?
17. How can your VBA code determine how many worksheets are present in a
workbook?
18. What is the function of the Workbook.CreateBackup property?
19. How would you obtain the full path and filename of a workbook?