Visual Basic for Applications
Event handling exercise
Average difficulty
This Visual Basic for Applications EVENT HANDLING 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: Event-handling macros
A full answer to this exercise is provided as part of the training course!
| 1) | Create and assign a macro so that it displays the following message when you try to close its file down: | ||
You may need to delete the macro to close your file down!
|
|||
| 2) | Create a macro which displays the following message when you click on cell B3 (note that the Address property of a cell gives its address in absolute format - eg $B$3): | ||
Beware - the address property is case-sensitive too!
|
|||
| 3) | Create a macro which displays the following message before you double-click (you can use VbCrLf twice in succession within your message box to create the new lines): | ||
Not that polite really ...
|
|||
| 4) | Create a macro which displays the following message when you try to open its file: | ||
The message which appears when you open a file
|
|||
|
|||
| 5) | Create a macro which immediately deletes any new worksheet you create, with the following message: | ||
If you know his phone number, please include this also.
|
|||
| 6) | Save and close any workbooks you have created (if you can!). | ||
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.
