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 vote129 views1 answer
Telephon call in vba
VBA
0 vote134 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote127 views1 answer
Handling a click event anywhere inside a panel vb
VBA
0 vote143 views1 answer
Vbnet click on dgv cells
VBA
5 votes143 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote120 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
1 vote973 views1 answer
Vba Remove Case Sensitivity
VBA
1 vote144 views1 answer
Vba optional
VBA
0 vote125 views1 answer
Vba array of integers
VBA
5 votes143 views1 answer
Excel vba right word from Long Integer
VBA