{"id":96516,"date":"2021-06-23T09:00:52","date_gmt":"2021-06-23T03:30:52","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=96516"},"modified":"2021-06-07T13:26:42","modified_gmt":"2021-06-07T07:56:42","slug":"vba-variables-data-types-constants","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/vba-variables-data-types-constants\/","title":{"rendered":"VBA Data Types, Variables and Constants"},"content":{"rendered":"

This \u201cVBA Variables, Data Types & Constants\u201d\u00a0 topic covers the concept of what variables and constants are. Knowing the difference between them and where to use them is really important.\u00a0<\/span><\/p>\n

What is a Variable?<\/h3>\n

A variable is a value that is declared in the code and used to store the value in the computer’s memory. It is very essential to declare your variable names and the data types. The data type defines which type of data will be stored in the variable.\u00a0<\/span><\/p>\n

Syntax:<\/strong><\/p>\n

Sub Module ( )\u00a0\u00a0\r\nDim\u00a0 Variable_Name As Variable_DataType\u00a0\r\nEnd Sub<\/pre>\n
In VBA, you can either declare a variable Implicitly or Explicitly.<\/span><\/p>\n
1. Implicitly<\/b>:<\/span><\/p>\n
 If the user is not sure about the data type and if they are likely to change, then they can declare the data type as a variant. The variant data type can store all kinds of data except the fixed-length string data type. Below is an example of a variable declared Implicitly.<\/span><\/p>\n
Example<\/strong>: Dim myArticle as Variant<\/span><\/p>\n
2. Explicitly<\/b>: When you use the “Dim” keyword in syntax, it’s declared explicitly.<\/span><\/p>\n
Example<\/strong>: Dim age As Integer<\/span><\/p>\n
To ensure Excel adds the variables to the option explicitly in the VBE, follow the below steps:<\/span><\/p>\n
1: Go to the tools menu and click on the options.\u00a0<\/span><\/p>\n
\"VBA<\/a><\/p>\n
2: Under the editor label, make sure that there is a tick mark available beside the required variable declaration.\u00a0<\/span><\/p>\n
\"Variables<\/a><\/p>\n
How do VBA variables get started?<\/h3>\n
Before executing the variables, we have to record a macro in the spreadsheet. To record a macro, follow the steps:\u00a0<\/span><\/p>\n
1: Go to the view tab and choose a macro.<\/span><\/p>\n
2: Provide a name to the macro and click on a new button.<\/span><\/p>\n
3: Record the Macro.<\/span><\/p>\n
4: Stop the Macro, once it\u2019s done.<\/span><\/p>\n
5: Now, click on the edit button in the dialog box to open the vba code editor.<\/span><\/p>\n
\"VBA<\/a><\/p>\n
6: Make the changes in the code and execute it.<\/span><\/p>\n
\"VBA<\/a><\/p>\n
Now, let\u2019s make use of a Dim statement in VBA to declare the variable. To declare a variable in the VBA. code editor is demonstrated below.<\/span><\/p>\n
Sub Variable()\r\nDim DataFlair As String\r\nDim articles as Integer\r\nEnd Sub<\/pre>\n
 <\/p>\n
Once the declaration is done, the variable reserves space in the memory to initialize the variable.<\/span><\/p>\n
Using Variable in VBA<\/h3>\n
The below code explains how to initialize a variable in VBA<\/span><\/p>\n
Sub Initialize()\r\n    Dim articles As Integer\r\n    articles = 5\r\n    MsgBox articles\r\nEnd Sub<\/pre>\n
 <\/p>\n
When you save and run the code, you get the following output:<\/span><\/p>\n
\"VBA<\/a><\/p>\n
Declaring a Variable in VBA<\/h4>\n
To declare a variable, follow the below steps:<\/span><\/p>\n
1: Open an Excel workbook and save it as an Excel macro-enabled workbook.\u00a0<\/span><\/p>\n
2: <\/span>\u00a0<\/b>Add a button using macros.\u00a0<\/span><\/p>\n
In order to create a macro,\u00a0<\/span><\/p>\n