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”).