Microsoft Excel VBA Macros training exercises | Selecting cells

Showing exercises 1-8 (out of 8)

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

This page has 0 threads Add post