If we leave out the type then VBA automatically sets the type to be a Variant. We can declare multiple variables in a single Dim statement Dim name As String, age As Long, count As Long We will examine these different types of Dim statements in the later sections. ARRAY ' Declaring a static array Dim arrScores(1 To 5) As Long Dim arrCountries(0 To 9) As String ' Declaring a dynamic array - set size below using ReDim Dim arrMarks() As Long Dim arrNames() As String ReDim arrMarks(1 To 10) As Long ReDim arrNames(1 To 10) As String End Sub ' Declaring and assigning using late binding Dim dict As Object Set dict = CreateObject( "Scripting.Dictionary") ' Declaring an object - create object below using Set Dim coll2 As Collection ' Declaring and creating an object Dim coll1 As New Collection OBJECT ' Declaring an object Dim sh As Worksheet BASIC VARIABLE ' Declaring a basic variable Dim name As String Dim count As Long Dim amount As Currency Dim eventdate As Date ' Declaring a fixed string Dim userid As String * 8 ' Declaring a dynamic array Dim () As īelow are examples of using the different formats ' Sub Examples() ARRAY ' Declaring a static array Dim (first To last) As ' Declaring an object using late binding Dim As Object ' 4. ' Declaring and creating an object Dim As New ' Declaring a fixed string Dim As String * BASIC VARIABLE ' Declaring a basic variable Dim As The format of the Dim statement is shown below ' 1. In later sections we will look at each type in more detail. In the next section, we will look at the format of the VBA Dim statement with some examples of each. Array – this is a group of variables or objects.External libraries such as the Dictionary.User objects created using Class Modules.Excel objects such as the Workbook, Worksheet and Range objects.subs/functions) and multiple properties(i.e. Object – This is a variable that can have multiple methods(i.e.You should avoid variants where possible but in certain cases it is a requirement to use them. Variant – VBA decides at runtime which type will be used.These are the types such as Long, String, Date, Double, Currency. Basic variable – this variable type holds one value.The following is a brief description of each type: They are all pretty similar in terms of syntax. It is used to declare variables in VBA.ĭeclare means we are telling VBA about a variable we will use later. VBA Worksheet What is the VBA Dim Statement
WHAT IS A MACRO IN EXCEL HOW TO
See here for how to add the Dictonary reference.ĭeclaring parameters in a sub or function *Note: Early binding requires that you add the reference file using Tools->References from the menu. Set dict = CreateObject( "Scripting.Dictionary")
5 How to Use Dim with Multiple Variables.
0 kommentar(er)
