vba - 我可以在 VBA 中同时声明和分配变量吗？

Question

我可以将以下声明和赋值转换为一行吗:

Dim clientToTest As String
clientToTest = clientsToTest(i)

或

Dim clientString As Variant
clientString = Split(clientToTest)

Answer 1

不幸的是，VBA 中没有速记，如果您希望将其放在一行以提高可读性，您将得到的最接近的是使用 : 连续字符的纯粹视觉效果；

Dim clientToTest As String:  clientToTest = clientsToTest(i)
Dim clientString As Variant: clientString = Split(clientToTest)

<小时/>

提示(其他答案/评论的摘要):也适用于对象(Excel 2010):

Dim ws  As Worksheet: Set ws = ActiveWorkbook.Worksheets("Sheet1")
Dim ws2 As New Worksheet: ws2.Name = "test"