Microsoft Excel VBA Macros training exercises | Recording macros and buttons

Showing exercises 1-6 (out of 6)

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Relatively easy
Course: Excel VBA macros
Exercise: Using Microsoft Excel to record macros to take the strain out of repetitive tasks.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Average difficulty
Course: Excel VBA macros
Exercise: Using absolute recording mode to record macros to repeat actions on the same set of cells.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Average difficulty
Course: Excel VBA macros
Exercise: Record a macro to change the colours of various parts of a house - including adding command buttons.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Average difficulty
Course: Excel VBA macros
Exercise: Record a macro to format a cell containing an elephant suitably, then strip out all of the unnecessary lines.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Harder than average
Course: Excel VBA macros
Exercise: Record a macro to apply data validation and protection to a cell, then strip out unnecessary lines.

Go to exercise ...

Category: Excel VBA Macros
Topic: Recording macros and buttons
Level: Harder than average
Course: Excel VBA macros
Exercise: Record a macro which will use a combination of absolute and relative cell referencing to add another period of data.

Go to exercise ...

This page has 0 threads Add post