User FAQs

If you have a question, please send it to us.


1) What is the difference between the LEFT function and the LEFT$ function ?
LEFT - Returns a Variant data type whose sub type is String.
LEFT$ - Returns a String data type.
A variable declared as a Variant will get a variant-string data type from both functions because of implicit data type conversion.
A variable declared as a String will get a string data type from both functions because of implicit data type conversion.

Dim myString As String 
myString = "some text"
Debug.Print VBA.Left(myString,4)
Debug.Print VBA.Left$(myString,4)

2) What is the difference between the TYPENAME function and the VARTYPE function ?
TYPENAME - Returns the data type of a variable as a string.
VARTYPE - Returns the data type of a variable as an integer enumeration.




© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext