VBA Learning Ideas of VBA learning notes

Advanced Knowledge points

1. SQL query Statements and ADO
2. Regular expressions and net catch
3. Forms and Controls
4. API class module and so on

Sorosay
Links: https://www.zhihu.com/question/26078625/answer/132542043
Source: Know
Copyright belongs to the author. Commercial reprint please contact the author for authorization, non-commercial reprint please specify the source.

1 hours

Familiarity with data types, variables, constants, and operators

1. Understand what data types VBA has

2. Know how to define variables and understand the differences when defining variables Public/dim/private

3. Know how to define constants

4. Understand what operators VBA has, especially the use of comparison operators and logical operators

Learn more click: VBA Basics (ii)

5 hours

Familiarity with VBA statements

Statement is the most basic and most common content of any language, it is worth spending more time to familiarize yourself with

1. Will write any kind of branch statement: If/select case

2. Any form of circular statement will be written: do while/do until/for/for each

3. Familiar with the use of the exit statement and Goto statement

Learn more click: VBA Basics (iii)

3 hours

Familiarity with VBA procedures and custom functions

1. Familiar with the different wording of the process: no parameter process and parametric process

2. Understanding the reference type of a parameter: value reference and address reference

3. Be familiar with custom functions and write at least 10 custom functions (such as how to write bond duration to custom functions and so on in VBA)

Click here: Procedure/Custom function

1 hours

Familiarity with the object model of VBA

The object model is the kernel of VBA and takes 1 hours to understand the principle

1. Familiarity with objects and the properties and methods of objects

2. Understand what an event is

Learn more: objects, properties, and methods

6 hours

3 common objects familiar to VBA

1. Practice the common properties and methods of the Range object

2. Practice the common properties and methods of Worksheet objects

3. Practice the common properties and methods of Workbook objects

For more information, click: Range Object/worksheet Object/workbook Object

2 hours

Familiarity with the use of VBA functions

1. Learn how VBA refers to Excel functions: for example, Worksheetfunction.sum ()

2. Familiar with common VBA functions

Click here: VBA function (i)/VBA function (ii)

6 hours

Familiarity with the use of arrays and Dictionary objects

1. Familiar with array usage and skilled use

2. Familiarity with the use of Dictionary objects

Learn more click: array/Dictionary object (i)/Dictionary object (ii)

5 hours

Learn about the usage of some very useful objects

1. Familiarity with the use of folder objects: Scripting.FileSystemObject

2. Understanding the Menu Bar object: Commandbar

3. Understanding Regular Expressions: REGEXP

Next...

1. Worksheet and Workbook events

2. Custom Form Design

3.CustomUI Design

4. Class modules

5.DLL Package

6.API

7.sql/com/xml

VBA Learning Ideas of VBA learning notes