Microsoft Project 2021 From Beginners to Advanced - Write a Macro

This video tutorial provides a comprehensive guide to using and editing macros in VBA. It begins with an introduction to the utility of macros and the objectives of the lesson. The tutorial then navigates through the VBA editor, explaining its interface and the structure of macros, including subroutines and modules. It covers how to edit and debug macros, focusing on the use of comments and properties. The video also provides a detailed analysis of macro code lines and instructions on modifying code for different tasks. Finally, it concludes with steps for finalizing and testing macros.

What is the primary focus of the lesson introduced at the beginning of the video?

• Understanding the basics of Microsoft Project

• Exploring issues and solutions related to a previously created macro

• Creating a new macro from scratch

• Learning about the history of VBA

Which window in the VBA editor displays the code for the selected macro or module?

• Properties window

• Project Explorer

• Immediate window

• Code window

What does the 'sub' keyword signify in a VBA macro?

• The start of a comment

• A subroutine

• The end of a macro

• A variable declaration

How can you add comments to a VBA macro?

• By starting the line with an apostrophe (')

• By using double slashes (//)

• By starting the line with an asterisk (*)

• By enclosing the text in brackets []

What should you do if you want to change the table view in a macro from 'work' to 'cost'?

• Change the module name to 'cost'

• Delete the existing line and re-record the macro

• Add a new line with 'Table apply name = cost'

• Modify the line to 'Table apply name = cost'

What happens if you don't specify a 'from date' or 'to date' in a macro?

• The macro will not run

• The macro will use the project's start and end dates

• The macro will use today's date

• The macro will prompt for dates each time

How can you prevent the overwrite prompt when saving a GIF file in a macro?

• By saving the file with a different name each time

• By adding 'Application.DisplayAlerts = False'

• By adding 'Application.DisplayAlerts = True'

• By manually confirming each overwrite