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 vote224 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote234 views2 answers
Excel vba protect cells with formula
VBA
0 vote240 views1 answer
Delete all controls in an area vb
VBA
0 vote223 views1 answer
Remove series name from legendvbnet
VBA
0 vote220 views1 answer
Excel vba send HTTP POST to server
VBA
9 votes491 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
0 vote241 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote242 views1 answer
For each item in folder outlook vba
VBA
0 vote230 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote212 views1 answer
Vb check if row has column
VBA