when to use the keyword "set"

It contains the address of a, whatever it stores. The compiler knows the data type (and therefore its length and storage format) based on its declaration. If undeclared (bad practice), it's a Variant, which contains information about its subtype (string, numeric, object, ...). See the VarType function.