How to use Assignment Operations in VBA?

Data Science, AI and ML
,
#1

Assignment Operators (there is only one assignment operator in VBA): = Assignment e.g. x = y where x is a variable or a writable property and y can be any numeric, logical, string literal, constant, or expression. x and y must be with the same data type.

One simple example is:

sub test()
 a=10
 Range("A1").value=a
end sub

In the above example, we first use the assignment operator “=” to assign value to variable “a” and then use the “=” operator to assign value of “a” to value of Range(“A1”).