Excel VBA Macros exercises on SELECTING CELLS

This page lists the 11 exercises about Selecting cells in Excel VBA Macros on our website:

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

Show this exercise

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

Show this exercise

Software:	Excel VBA Macros
Topic:	Selecting cells
Level:	Relatively easy
Exercise:	Write a subroutine to enter your details into an application form for a dating agency.

Show this exercise

Software:	Excel VBA Macros
Topic:	Selecting cells
Level:	Relatively easy
Exercise:	Write code to change the colour of cells and sink ships in a rudimentary version of Battleships.

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	Excel VBA Macros
Topic:	Selecting cells
Level:	Average difficulty
Exercise:	Use the End and Offset properties in Excel VBA to copy the details of dating-agency applicants to the end of a list.

Show this exercise

Software:	Excel VBA Macros
Topic:	Selecting cells
Level:	Average difficulty
Exercise:	Write a macro to select a column of celebrity marriage data, then amend it to select a rectangular block.

Show this exercise

Software:	Excel VBA Macros
Topic:	Selecting cells
Level:	Average difficulty
Exercise:	Write a macro to select the last task in a block of tasks for Bob the Builder.

Show this exercise

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

Show this exercise

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

Show this exercise

You can search our full list of VBA exercises here. Or why not learn to do them the right way on one of our VBA training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post