VBA Learning Ideas of VBA learning notes

Source: Internet
Author: User
Tags logical operators object model

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.