EXERCISE TOPIC▼
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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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 |
| Courses: | Excel VBA macrosFast track Excel VBA |
| 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