Answers for "variable vba"

VBA
0

vba type variable

debug.print TypeName(my_var)   ' String, Integer, Date...
debug.print VarType(my_var)	   ' vbLong, vbDate...
Posted by: Guest on January-23-2021
0

vba declare variable with value

Dim myString As String:  myString = "aaa bbb"
Dim myStringCaps As String:  myStringCaps = UCase("aaa bbb")
Dim myPart As Variant: myPart = Split(myString)
Dim ws As Worksheet: Set ws = ThisWorkbook.Worksheets(1)
Const MY_CONST As String = "Value"
Posted by: Guest on January-22-2021

Code answers related to "VBA"

Browse Popular Code Answers by Language