About Types of Variables Excel(Excel) Macro(VBA)

This section describes the types used to declare variables in "Dim Variables".

table of contents

Typical variable types

Here are some typical variable types that you only need to remember. I use almost only these.

Variable Types	range of data that can be stored
string	character string
long	Integer (-2,147,483,648 to 2,147,483,647)
double	minority Negative values: approximately -1.7 x 10 to the 308th power to the -324th power of approximately -4.9 x 10 Positive values: approximately 4.9 x 10 to the -324th power to the 308th power of approximately 1.7 x 10
Workbook	workbook
Worksheet	worksheet
Range	Cell Range

The usage of Workbook, Worksheet, and Range is slightly different and will be explained separately.

Use "string" to store strings.

Sub Show name()
    Dim name As String
    name = "Tanaka".
    MsgBox name
End Sub

When I run this code

was displayed.

Dim name As String" to declare that "name" is a string, and

The string "Tanaka" is stored in "name" with "name = "Tanaka".

Use "long" to store integers.

Sub Display Age()
    Dim age As Long
    age = 30
    MsgBox age
End Sub

When I run this code

was displayed.

Dim age As Long" to declare that "age" is an integer, and

The integer "30" is stored in "age" with "age = 30".

If you want to store a small number, use "Double".

Sub Display of quarters()
    Dim quarter As Double
    quarter = 1 / 4
    MsgBox quarter
End Sub

When I run this code

was displayed.

Dim quarter As Double" to declare that "quarter" is a minority, and

quarter = 1 / 4" stores "1/4 calculation result" in "quarter".

As we continue to learn more about vba.

Variable Types	range of data that can be stored
Date	Date January 1, 100 to December 31, 9999
Boolean	Call it Boolean. True or False is entered.

Other variable types I rarely use

Variable Types	range of data that can be stored
Integer	Integer (32,768 to 32,767) Same integer as long, but much smaller range.
Byte	Integer (0-255) Same integer as long, but much smaller range.
Single	Same small number as Double, but smaller range. Negative values: -3.4 x 10 to the 38th power to the -1.4 x 10 -45th power Positive values: 1.4 x 10 to the -45th power to the 38th power of 3.4 x 10
Variant	No distinction between numbers and strings, as anything can be entered.
Object	Workbook, Worksheet, Range, etc. are all included, but these Better to use differently for Workbook, Worksheet and Range.