EXERCISE TOPIC▼
- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
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 |
| Courses: | Fast track Excel VBAAdvanced VBA |
| 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 |
| Courses: | Fast track Excel VBAAdvanced VBA |
| 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 |
| Courses: | Fast track Excel VBAAdvanced VBA |
| 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 |
| Courses: | Fast track Excel VBAAdvanced VBA |
| 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 |
| Courses: | Fast track Excel VBAAdvanced VBA |
| 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 |
| Courses: | Fast track Excel VBAAdvanced VBA |
| 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