Microsoft Excel VBA Macros training exercises (page 1 of 2)

Showing exercises 1-20 (out of 37)

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Relatively easy
Course: Excel VBA macros
Exercise: Using Microsoft Excel to record macros to take the strain out of repetitive tasks.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Average difficulty
Course: Excel VBA macros
Exercise: Record a macro to format a cell containing an elephant suitably, then strip out all of the unnecessary lines.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Average difficulty
Course: Excel VBA macros
Exercise: Record a macro to change the colours of various parts of a house - including adding command buttons.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Average difficulty
Course: Excel VBA macros
Exercise: Using absolute recording mode to record macros to repeat actions on the same set of cells.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Harder than average
Course: Excel VBA macros
Exercise: Record a macro which will use a combination of absolute and relative cell referencing to add another period of data.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Harder than average
Course: Excel VBA macros
Exercise: Record a macro to apply data validation and protection to a cell, then strip out unnecessary lines.

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Relatively easy
Course: Excel VBA macros
Exercise: Write a simple macro to guide Red Riding Hood through a maze, using lots of OFFSET commands.

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Relatively easy
Course: Excel VBA macros
Exercise: Select one cell in a battleships grid relative to another.

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Relatively easy
Course: Excel VBA macros
Exercise: Write macros to select various ranges absolutely using a battleships game as template.

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Relatively easy
Course: Excel VBA macros
Exercise: Write one or more simple macros to fill in capital cities on different worksheets (shows selecting worksheets and selecting cells).

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Average difficulty
Course: Excel VBA macros
Exercise: Write a macro to select a column of data, then amend it to select a rectangular block (both using the END keyword).

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Average difficulty
Course: Excel VBA macros
Exercise: Write a macro to select the last task in a block of tasks.

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Harder than average
Course: Excel VBA macros
Exercise: Practise on a battleships grid using more difficult selection techniques, such as resizing a selection and using the UNION method.

Go to exercise ...

Category: Excel VBA Macros
Topic: Selecting cells
Level: Harder than average
Course: Excel VBA macros
Exercise: Create a macro to select almost down to the bottom of a block of Muppets data (using OFFSET and END).

Go to exercise ...

Category: Excel VBA Macros
Topic: Messages and variables
Level: Relatively easy
Course: Excel VBA macros
Exercise: Write a macro which asks for your name using INPUTBOX and then displays a welcome message using MSGBOX.

Go to exercise ...

Category: Excel VBA Macros
Topic: Messages and variables
Level: Average difficulty
Course: Excel VBA macros
Exercise: Write a macro to input a dinosaur name using an INPUTBOX, find it on a spreadsheet and then display the height of the dinosaur using MSGBOX.

Go to exercise ...

Category: Excel VBA Macros
Topic: Messages and variables
Level: Harder than average
Course: Excel VBA macros
Exercise: Use MsgBox to display a message asking user whether they want to continue or not, and process answer.

Go to exercise ...

Category: Excel VBA Macros
Topic: Visual Basic explained
Level: Relatively easy
Course: Excel VBA macros
Exercise: Spot why the pictures are not genuine Visual Basic collections.

Go to exercise ...

Category: Excel VBA Macros
Topic: Visual Basic explained
Level: Average difficulty
Course: Excel VBA macros
Exercise: Converting English sentences into Visual Basic, using properties, methods, objects and collections.

Go to exercise ...

Category: Excel VBA Macros
Topic: Loops and conditions
Level: Relatively easy
Course: Excel VBA macros
Exercise: Write a macro to loop over cells following instructions until you reach the cottage of Red Riding Hood!.

Go to exercise ...

This page has 0 threads Add post