当然可以。在VBA(Visual Basic for Applications)中,您可以在声明变量时直接分配初始值。以下是一些示例:
Dim x As Integer = 10
Dim y As String = "Hello"
Dim arr(3) As Integer
arr(0) = 1
arr(1) = 2
arr(2) = 3
arr(3) = 4
Dim obj As Object
Set obj = CreateObject("Excel.Application")
在VBA中,您可以使用Dim
关键字声明变量,并在声明时分配初始值。这使得代码更简洁,易于阅读和维护。
领取专属 10元无门槛券
手把手带您无忧上云