EXERCISE TOPIC▼
- Access exercises (91)
- C# exercises (79)
- Excel exercises (278)
- Power Apps exercises (13)
- Power Automate exercises (18)
- Power BI exercises (139)
- Python exercises (28)
- Report Builder exercises (141)
- SQL exercises (198)
- SSAS exercises (51)
- SSIS exercises (46)
- SSRS exercises (99)
- VBA exercises (85)
- Visual Basic exercises (46)
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