VBA Lesson 19: VBA for Excel Variables
You will start developing complex and sophisticated programs in Excel and you will start working with very large sets of data when you discover the variables.
A variable is an object that you create and in which you can store text, dates, numbers or almost anything else. Why should you use variable? The first good reason is to make your code dynamic, to avoid hard coding some values.
Hard Coding vs Dynamic Coding
You are hard coding when you write:
You are dynamically coding when you enter the name of the file in an cell (A1) of your Excel sheet and you write.
You will also create variables to count the number of rows, store the result in a variable and then do something as many time as there are rows.
For varCounter = 1 to varNbRows
In the VBA procedure above the value in each cell is multiplied by 2 then the cell below is selected. This action is repeated as many times as there are rows in the set of data.
We hope you have enjoyed this introduction to lesson 19
All the Lessons
Lesson 1: Visual Basic Editor (VBE) in Excel, Lesson 2: The Project Window in the Visual Basic Editor of Excel, Lesson 3: The Properties Window in the Visual Basic Editor of Excel, Lesson 4: The Code Window in the Visual Basic Editor of Excel, Lesson 5: Developing Macros in the VBE, Lesson 6: Testing Macros in the VBE, Lesson 7: Excel Macro Recorder, Lesson 8: Macros Help and Assistance, Lesson 9: VBA Events, Lesson 10: VBA Security and Protection, Lesson 11: VBA Coding Tips, Lesson 12: Dealing with Errors, Lesson 13: Working with the Application, Lesson 14: Working with the Workbooks, Lesson 15: Working with the Worksheets, Lesson 16: Moving Around the Worksheet, Lesson 17: Working with Message and Input Boxes, Lesson 18: Excel VBA Vocabulary to Filter and Sort Data. Lesson 19: Working with Variables, Lesson 20: Working with Statements, Lesson 21: Working with Functions, Lesson 22: Working with external data and SQL, Lesson 23: Working with Windows and other Microsoft Programs FROM Excel, Lesson 24: Forms (Userforms) in VBA for Excel, Lesson 25: Userforms Properties and VBA Code, Lesson 26: Properties and VBA code for Command Buttons, Lesson 27: Properties and VBA code for Labels, Lesson 28: Properties and VBA code for Text Boxes, Lesson 29: Properties and VBA code for Combo Boxes, Lesson 30: Properties and VBA code for List Boxes, Lesson 31: Properties and VBA code for Check Boxes, Option Buttons and Frames, Lesson 32: Properties and VBA code for Spin Buttons, Lesson 33: Excel Image Controls
This website and the downloadable Tutorial on Excel Macros are divided in three sections:
Section 1: Excel Macros Programming: Lessons 1 to 10
Section 2: Excel VBA Vocabulary: Lessons 11 to 23
Section 3: Forms and Controls in VBA for Excel: Lessons 24 to 33