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: Advanced 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.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: Passing arguments
Level: Relatively easy
Course: Advanced VBA
Exercise: Create a couple of simple macros taking arguments - one to display a message, and one to protect or unprotect a worksheet.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: Passing arguments
Level: Average difficulty
Course: Advanced VBA
Exercise: Create a function to calculate Olympic medal points - this should take 3 arguments and return a single points total.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: Passing arguments
Level: Average difficulty
Course: Advanced VBA
Exercise: An exercise to add records to a database, using an optional argument for the postcode and also showing enumerations.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: Passing arguments
Level: Average difficulty
Course: Advanced VBA
Exercise: Writing a program to calculate the factorial of a number without loopin, using recursive programming.

Go to exercise ...

Software: Advanced VBA
Version: Any MS Office versions
Topic: Passing arguments
Level: Harder than average
Course: Advanced 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.

Go to exercise ...

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