Microsoft Excel
Recording macros and buttons exercise
Average difficulty
This Microsoft Excel RECORDING MACROS AND BUTTONS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl EXCEL VISUAL BASIC course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Exercise: Recording formatting macros and copying code you need
A full answer to this exercise is provided as part of the training course!
| 1) | Record a macro to put a green outline border round the currently selected cells: |
A typical result of running your macro
|
|
| 2) | Strip unnecessary lines out of this macro so that it is as short as possible (you should be able to get it down to 8 lines!), then test that it still works by selecting a different block of cells. |
| 3) | Record a second macro to make the selected cells have 14 point font and centre alignment horizontally: |
This is what your screen might look like after running your macro
|
|
| 4) | Now again strip out unnecessary lines, and test that this cut-down macro still works - you should be able to get your macro down to 2 lines! |
Thank you for showing an interest in this Excel Visual Basic training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.
