Description
In this course, you will learn:
- Learn the terms you'll need to get started with macros and VBA.
- Simple macros and VBA will be able to read and write.
- You will be able to boost your productivity by using shortcut keys.
- Find out how to use the "Record Macro" feature.
- Learn how to make the programming screen your own.
- You can learn about the fonts that are recommended for programming.
- Learn how to execute macros in five different ways.
- Learn the fundamentals of excellent programming.
Syllabus:
- The big picture of the macro
- What makes you happy when you can use macros?
- To learn efficiently
- Before the demo
- Try manipulating strings
- Try to make a calendar
- Try using your own tools with macros
- Trying to deal with the God Excel problem "Corporate tax return"
- Try changing the file name
- Export the image file name to Excel so that the image can be seen from Excel
- Download the macro experience file
- Precautions when opening a macro-enabled book
- Experience the rename macro
- Experience the calendar creation macro
- Experience the image pasting macro
- What the macro is doing
- Display the development tab in Excel 2013, 1016
- Display the VBE screen
- Excel Preferences
- VBE preferences
- Font settings
- Let's display the development tab and set the environment
- Launch VBE
- Add module
- Write code in the procedure Part 1
- Write code in the procedure Part 2
- Let's write a macro for the time being
- How to read the VBE screen
- Glossary of macros
- Procedure naming convention
- Supplement when naming in Japanese
- How to read the code
- How to write code
- How to enter white space and time
- Let's write a macro!
- How to save macros
- Automatic recording of macros How to use
- Let's find out how to write code with automatic recording
- Macro auto-recording Invoice initialization
- Automatic recording of macros Try to use it in practice
- Let's do the same
- How to execute from the VBE screen and how to execute from the button
- How to execute from the development tab and how to execute macros continuously