Creating & Editing Macros in Excel Microsoft 365 for Windows
Excel Microsoft 365 (Windows)
| Expert
- 10 videos | 46m 48s
- Includes Assessment
- Earns a Badge
In Excel for Office 365 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document. In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code.
WHAT YOU WILL LEARN
-
Identify the key components of a macroCreate, edit and remove modulesInsert procedures into your macro modulesWrite code in visual basicDeclare variables and insert constants
-
Insert objects and create object collectionsInsert and test operatorsExecute actions under conditionsCreate eventsManage and correct macro errors
IN THIS COURSE
-
3m 27sFrom the Visual Basic editor, you can get a complete view of your macros and their components. Discover how to identify the key macro components such as procedure, sub procedures and comments in Excel for Office 365. FREE ACCESS
-
4mIn the Visual Basic editor your macros are contained within the project component modules. You can add modules, rename modules and start adding code to your modules within Excel for Office 365. FREE ACCESS
-
4m 17sIn Excel for Office 365, modules are used to store procedures. In the Visual Basic editor you can manually insert procedures or use the insert tool to quickly insert public and private procedures in your modules. FREE ACCESS
-
5m 47sWith Visual Basic in Excel for Office 365 you can write your own code from scratch. See how to add properties, methods and comments. You can also edit your code formatting by using the edit tools. FREE ACCESS
-
3m 14sWhen creating macros in Excel for Office 365, you will need to know how to declare and assign variables. You'll also see how to insert constants to save time when writing code in Visual Basic. FREE ACCESS
-
6m 38sVisual Basic works with an object model program. You can easily insert an object, browse the object library and create object collections with Excel for Office 365. FREE ACCESS
-
4m 18sYou can insert operators into your macros to perform calculations. It's also possible to insert comparison and logical operators to perform calculations if certain criteria are met. See how to insert and test operators in Excel for Office 365. FREE ACCESS
-
4m 19sYou can insert procedures with conditions using If, Then, and Else to return specific values. Excel for Office 365 also gives you the possibility to work with cases by inserting the CaseValue procedure. FREE ACCESS
-
5m 2sEvent procedures enable you to interact with objects. You can rename spreadsheets and create reminders with the event procedure available in Excel for Office 365. FREE ACCESS
-
5m 46sThere are three types of errors that can occur in macros: syntax, runtime and logic errors. See how to identify and correct macro errors with Excel for Office 365. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.