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 votes282 views2 answers
Vba array length
VBA
2 votes279 views2 answers
Constructor vb.net
VBA
0 vote302 views1 answer
Vba cell all borders
VBA
0 vote298 views1 answer
Vba excel do not recalculate before save
VBA
0 vote332 views1 answer
Vba userform textbox wrap text
VBA
0 vote290 views1 answer
Convert number to minutes in vba
VBA
1 vote291 views1 answer
Excel vba compare 2 rows
VBA
0 vote263 views1 answer
Add items to combobox vb.net
VBA
4 votes296 views1 answer
Vba create directory
VBA
0 vote283 views1 answer
Reset border color textbox vba
VBA