The difference between object variables and regular variables : Object Variable Set « Data Type « VBA / Excel / Access / Word

1.	Access
2.	Application
3.	Data Type
4.	Data Type Functions
5.	Date Functions
6.	Excel
7.	File Path
8.	Forms
9.	Language Basics
10.	Math Functions
11.	Outlook
12.	PowerPoint
13.	String Functions
14.	Windows API
15.	Word
16.	XML

VBA / Excel / Access / Word » Data Type » Object Variable Set

The difference between object variables and regular variables

 

Sub sSub()

    Dim intVar1 As Integer

    Dim intVar2 As Integer

    intVar1 = 5

    intVar2 = intVar1

    intVar1 = 10

    Debug.Print intVar1 'Prints 10

    Debug.Print intVar2 'Prints 5

End Sub

Related examples in the same category

1.	The Object Data Type Set
2.	Object Data Types
3.	Object Variables
4.	reference can be assigned to an object variable so that you can easily refer to the new object in later code
5.	VBA has the ability to interact with Access to help create and edit objects
6.	Object variable
7.	With...End With
8.	VBA knows that anything starting with a period is a property or a method of the object following the With
9.	eliminate the object variable when using With statement
10.	Compromise with a combination of object variables and With...End With:
11.	Identifying the type of a selected object: uses the TypeName function, which returns the type of the selected object (as a string):

www.java2java.com | Contact Us

All other trademarks are property of their respective owners.