HADM 5760 VBA PRELIM INFORMATION
Disclaimer: This document is intended to help you prepare for the VBA prelim. It does not bind me in any way. It is not a contract or a guarantee. This document reflects my current thinking about what will be on the exam and where you should focus your studying. Hopefully it helps you, but the content of the exam is subject to change at any time without notification.
When: October 23. @7:00 PM
Where: Bin Lab C (Small lab across from classroom)
How Many Problems: 1
How Long to Do It: 30 Minutes
Resources: The exam is closed book. Feel free to record a macro to get help with the object model. There will be no questions during the exam. The instructions are clear. If you are in doubt, follow best practice as demonstrated in class.
Hints: (Don't ask for more info on these hints or examples. This is all I'm comfortable giving you. More examples and explanations can be found online as you study)
◆ Practice looping through a range using nested For loops (NOT For Each loops)
o Pseudocode:
For RowCount = 1 To NumRows
For ColCount = 1 To NumCols
. . . .
. . . .
Next ColCount
Next RowCount
◆ Know how to use the VBA Worksheet.Cells property to specify a cell in a range.
o Click here to look it up
o Know how to use Worksheet.Cells in combination with nested For Loops to loop through a range and write values to a cell.
◆ Know how to use the VBA Worksheet.UsedRange property
o Click here to look it up
◆ Know how to use the VBA Range.ClearContents method
o Click here to look it up
Things you DON'T need to know:
indefinite loops, arrays, charting, online file handling, customizing Excel, ActiveX, UserForms