Microsoft Advanced VBA training exercises (page 1 of 2)

Showing exercises 1-20 (out of 29)

Category: Advanced VBA
Topic: Revision of VBA
Level: Relatively easy
Course: Advanced VBA
Exercise: Write a macro to loop over a number of holidays, getting the details for each and writing these out to the immediate window.

Go to exercise ...

Category: Advanced VBA
Topic: Revision of VBA
Level: Relatively easy
Course: Advanced VBA
Exercise: Loop over film cells, picking out those films having lots of reviews and colouring them.

Go to exercise ...

Category: Advanced VBA
Topic: Revision of VBA
Level: Average difficulty
Course: Advanced VBA
Exercise: List out the number of shapes on each slide in a presentation, by looping over the slides.

Go to exercise ...

Category: Advanced VBA
Topic: Revision of VBA
Level: Average difficulty
Course: Advanced VBA
Exercise: An exercise to loop over collections of characters in a Word paragraph.

Go to exercise ...

Category: Advanced VBA
Topic: Revision of VBA
Level: Average difficulty
Course: Advanced VBA
Exercise: An exercise to loop over all of the controls on a form, counting how many there are of each type.

Go to exercise ...

Category: Advanced VBA
Topic: Links to other applications
Level: Relatively easy
Course: Advanced VBA
Exercise: Create a PowerPoint macro writing slide information for an existing presentation to a new workbook in Excel.

Go to exercise ...

Category: Advanced VBA
Topic: Links to other applications
Level: Relatively easy
Course: Advanced VBA
Exercise: Loop over cells in Excel, copying contents to Word bookmarks to write a letter.

Go to exercise ...

Category: Advanced VBA
Topic: Links to other applications
Level: Average difficulty
Course: Advanced VBA
Exercise: Looping over words in a document, writing each to Excel and counting instances.

Go to exercise ...

Category: Advanced VBA
Topic: Links to other applications
Level: Harder than average
Course: Advanced VBA
Exercise: A form with a combo box getting its values from an Access query.

Go to exercise ...

Category: Advanced VBA
Topic: FileSystemObjects
Level: Average difficulty
Course: Advanced VBA
Exercise: Using FileSystemObjects to move, copy, rename and delete files and folders.

Go to exercise ...

Category: Advanced VBA
Topic: FileSystemObjects
Level: Harder than average
Course: Advanced VBA
Exercise: Consolidate data from files on your computer using file references.

Go to exercise ...

Category: Advanced VBA
Topic: Working with text files
Level: Relatively easy
Course: Advanced VBA
Exercise: Write a macro to loop over the lines in a text file, reading each in and storing the message.

Go to exercise ...

Category: Advanced VBA
Topic: Working with text files
Level: Average difficulty
Course: Advanced VBA
Exercise: Read in a text file which contains the specification of a house, and colour Excel cells accordingly to draw it.

Go to exercise ...

Category: Advanced VBA
Topic: FileDialogs
Level: Relatively easy
Course: Advanced VBA
Exercise: Using FileDialogs to create customised file dialog boxes.

Go to exercise ...

Category: Advanced VBA
Topic: FileDialogs
Level: Average difficulty
Course: Advanced VBA
Exercise: Creating a dialog box allowing multiple selection of files.

Go to exercise ...

Category: Advanced VBA
Topic: Class modules
Level: Relatively easy
Course: Advanced VBA
Exercise: Create a class to allow users to run a mortgage model (properties are things like house price and deposit).

Go to exercise ...

Category: Advanced VBA
Topic: Class modules
Level: Average difficulty
Course: Advanced VBA
Exercise: An exercise to create a game class, such that when you set the home/away team name and score, an Add method adds the result to a table.

Go to exercise ...

Category: Advanced VBA
Topic: Class modules
Level: Average difficulty
Course: Advanced VBA
Exercise: Create a class to allow you to create simple pie charts. The chart has 3 simple properties - title, data range and slice to explode - and one method, print preview.

Go to exercise ...

Category: Advanced VBA
Topic: Advanced class modules topics
Level: Harder than average
Course: Advanced VBA
Exercise: An exercise to create a Holiday class and a strongly-typed Holidays collection, and test that these work.

Go to exercise ...

Category: Advanced VBA
Topic: Linking to data
Level: Average difficulty
Course: Advanced VBA
Exercise: Create an input form for Beatles, linking Excel to Access using ADO, then read Beatles back into an array using REDIM PRESERVE.

Go to exercise ...

This page has 0 threads Add post