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

0 vote299 views2 answers
Excel vba prevent save
VBA
0 vote322 views1 answer
Vb ternary
VBA
0 vote326 views1 answer
Vba run command
VBA
0 vote323 views1 answer
Vba excel parser xml
VBA
0 vote326 views1 answer
Reference to a non-shared member requires an object reference
VBA
0 vote310 views1 answer
Excel vba saveas no prompt for overwrite
VBA
-1 vote295 views1 answer
Text to speech vb.net
VBA
0 vote297 views1 answer
Vba loop through table
VBA
8 votes425 views1 answer
Vba make a short integer from two bytes
VBA
0 vote325 views1 answer
Menus act like radio buttons vb.net
VBA