Week 7, starting Monday 13th November
The Torrington Place cluster room is available again, so Thursday's session will take place there as usual.
All work should be completed in the session for which it is set. Work carried over for marking in the following week will only receive half the credit. Note that the session ends at 5:30pm, and work should be marked by this time. Please get each exercise marked as you finish it.
This week you should complete the following tasks:
- VBA task 1 (recording a macro)
- VBA task 2 (editing and annotating a macro)
This week you will begin the Visual Basic exercises. In the first one VBA task 1 you will use Excel's "Record New Macro" procedure from the Tools Menu to record a simple macro.
The second exercise VBA task 2 is an extension of this whereby you record a macro then edit it, and annotate it with comments.