Vba set vs dim

Vba dim and set value

' More visual (':' is just a line separator)
Dim sTest As String:  sTest = clientsToTest(i)
Dim sVariant As Variant: sVariant = Split(sTest)
' Objects
Dim ws as New Workbook

Source: grepper.com

Similar codes

4 votes113 views2 answers
Vba array length
VBA
0 vote123 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote119 views1 answer
Add items to combobox vb.net
VBA
0 vote123 views1 answer
Convert number to minutes in vba
VBA
0 vote123 views1 answer
Vbnet check if string is only numbers
VBA
0 vote85 views1 answer
Vba select file in folder
VBA
0 vote121 views1 answer
Reference to a non-shared member requires an object reference
VBA
-1 vote139 views1 answer
How save excel through visual basic
VBA
0 vote130 views3 answers
Write to text file vb.net
VBA
0 vote124 views1 answer
Move bindingnavigator vb
VBA