code

Excel object

form object

Module vs class module

1

0~255, integer

age

Overtime days

2

Logical judgment, True/False

2

-2768~32767, integer

Number of people

%

4

-2147483648~2147483647, integer

Population

&

4

-3.402823E38~-1.401298E-45

PI

!

8

Negative number: -1.79769313486232E308~ -4.94065645841247E-324

Positive number: 4.94065645841247E-324~1.79769313486232E308

Basic wage

#

8

-922,337,203,685,477.5808~922,337,203,685,477.5807

@

Without decimals: /-79,228,162,514,264,337,593,543,950,335

Including decimals: /-7.9228162514264337593543950335

Smallest non-zero value: /-0.00000000000000000000000000001

14

Date range: January 1, 100 to December 31, 9999

Time range: 0:00:00~23:59:59

8

date

10 string length

0 ~ about 2 billion

Name, job number

$

string length

1 ~ about 65,400

$

4

Object variables, used to reference objects

In addition to fixed-length String data and user-defined types, it can contain any kind of data.

If it is a numerical value, the maximum range can be Double.

If it is a character, it is consistent with the variable-length String range.

The range of each element is the same as the range of its own data type

Dim/Static, acts on this process, local variable

Dim/Private, acts on the module where it is located, module-level variables

Public, applies to all modules, announces variables

Share a name: array name

Multiple variables of the same type form an array

The elements are stored in the array in order and are distinguished by index numbers.

Arrays are variables

array dimensions

Declare dynamic array

Other ways to create

Sum

Find the difference, find the opposite

Product

Seek business

Divisible

index

Take remainder

equal

expression1=expression2

Returns True when the two expressions are equal, False otherwise.

less than

expression1<expression2

Returns True when expression1 is less than expression2, otherwise returns False

more than the

Expression1>Expression2

Returns True when expression 1 is greater than expression 2, otherwise returns False

less than or equal to

expression1<=expression2

Returns True when expression1 is less than or equal to expression2, otherwise returns False

greater than or equal to

Expression1>=Expression2

Returns True when expression1 is greater than or equal to expression2, otherwise returns False

not equal to

Expression1<>Expression2

Returns True when expression1 is not equal to expression2, otherwise returns False

Compare reference variables of two objects

Object 1 Is Object 2

Returns True when object 1 and object 2 refer to the same object, otherwise returns False

Compare two strings to see if they match

String 1 Like String 2

Returns True when string 1 matches string 2, otherwise returns False

The expressions on both sides are text strings, and the connection is performed; the numerical values ​​are calculated.

Regardless of the data type of the operator, the connection operation is performed

and

Expression1 And Expression2

If the values ​​of expression 1 and expression 2 are both Ture, return Tue, otherwise return False

or

Expression1 Or Expression2

If one of the values ​​of expression 1 and expression 2 is True, Tue will be returned, otherwise False will be returned.

No

Not expression

If the value of the expression is True, return False, otherwise return True

XOR

Expression1 Xor Expression2

When the values ​​of expression 1 and expression 2 are different, True is returned, otherwise False is returned.

equivalence

Expression 1 Eqv Expression 2

When the values ​​of expression 1 and expression 2 are the same, True is returned, otherwise False is returned.

contains

Expression1 Imp Expression2

The value of expression 1 is True, and when the value of expression 2 is False, False is returned, otherwise Ture is returned; equivalent to Not expression 1 or expression 2

Replace any number of characters

replace any character

replace any number

Replace any character in [charlist]

Replace any character not in [charlist]

public process

private process

Currently active cell

The active chart in the currently active workbook

The active worksheet in the currently active workbook

currently active window

Currently active workbook

All chart worksheets in the currently active workbook

All selected objects in the currently active workbook

All Sheet objects in the currently active workbook, including ordinary worksheets, chart worksheets, Ms Excel 4.0 macro table worksheets and Ms Excel 5.0 dialog worksheets

All Worksheet objects in the currently active workbook (ordinary worksheets)

All currently open workbooks

content

number

address

Select cells

Selectively clear cells

Copy cell range

Cut cells

delete cell

Left, source cell <Ctrl left arrow key>

Right, source cell <Ctrl right arrow key>

Up, source cell <Ctrl up arrow key>

Down, source cell <Ctrl down arrow key>

Occurs when a worksheet is activated

After double-clicking the worksheet, the default double-click operation occurs before

After right-clicking the worksheet, the default right-click operation occurs before

Occurs after recalculating the worksheet

Occurs when a cell changes

Occurs when changing from an active worksheet to an inactive worksheet

Occurs when any hyperlink in the stand-alone worksheet

Occurs after updating pivot table

Occurs when the selection changes

For entering and displaying static text

Used to combine multiple other controls

Used to execute macro commands

Selection control, multiple selections possible

Selection, usually several option buttons are used together in a combo box, and only one of them can be selected at the same time

Displays a list of multiple options from which to choose one

Provides multiple options to choose from, one of which can be selected

Includes horizontal and vertical

Click the control's arrow to select a value