WISE OWL EXERCISES
VBA EXERCISES
EXCEL VBA MACROS EXERCISES
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. |
| 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. |
| 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. |
| 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). |
| 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. |
| 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. |
| 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. |
| 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. |
| 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). |
| 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. |
| 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). |
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