WISE OWL EXERCISES
VBA EXERCISES
ADVANCED VBA EXERCISES
Advanced VBA exercises on PASSING ARGUMENTS
This page lists the 6 exercises about Passing arguments in Advanced VBA on our website:
| Software: | Advanced VBA |
| Version: | Any MS Office versions |
| Topic: | Passing arguments |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Create a routine to send an Outlook message. The argument list should vary according to whether you are copying the message to anyone. |
| Software: | Advanced VBA |
| Version: | Any MS Office versions |
| Topic: | Passing arguments |
| Level: | Relatively easy |
| Course: | |
| Exercise: | Create a couple of simple macros taking arguments - one to display a message, and one to protect or unprotect a worksheet. |
| Software: | Advanced VBA |
| Version: | Any MS Office versions |
| Topic: | Passing arguments |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Create a function to calculate Olympic medal points - this should take 3 arguments and return a single points total. |
| Software: | Advanced VBA |
| Version: | Any MS Office versions |
| Topic: | Passing arguments |
| Level: | Average difficulty |
| Course: | |
| Exercise: | An exercise to add records to a database, using an optional argument for the postcode and also showing enumerations. |
| Software: | Advanced VBA |
| Version: | Any MS Office versions |
| Topic: | Passing arguments |
| Level: | Average difficulty |
| Course: | |
| Exercise: | Writing a program to calculate the factorial of a number without loopin, using recursive programming. |
| Software: | Advanced VBA |
| Version: | Any MS Office versions |
| Topic: | Passing arguments |
| Level: | Harder than average |
| Course: | |
| Exercise: | Write a macro to work out Yahoo-style breadcrumbs given a table of regions. Each region record contains the region id and name and the id of the parent region. |
You can search our full list of VBA exercises here, or why not have a look at our other VBA training resources?
This page has 0 threads
Add post