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
Version: Any version of Excel
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 ...

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

Go to exercise ...

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

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
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 ...

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

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
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 ...

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

Go to exercise ...

Software: Excel VBA Macros
Version: Any version of Excel
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 ...

Software: Excel VBA Macros
Version: Any version of Excel
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 ...

Software: Excel VBA Macros
Version: Any version of Excel
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 ...

Software: Excel VBA Macros
Version: Any version of Excel
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 ...

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