VBA: How to declare a variable and set initial values in one line?

[gifariz]

Hi, I want to write variable declaration and set the initial values in one line. I see some examples for that, but it doesn't work in my excel. Here are some examples that failed:

Dim longArray() As Long = {0, 1, 2, 3}
Dim longArray As Long() = {0, 1, 2, 3}
Dim longArray = New Long() {0, 1, 2, 3}

First and last example are taken from official microsoft documentation website [1] [2]

Any suggestion?
Thank you in advance

 

[RayFrye]

Maybe:
Dim longArray(0, 1, 2, 3)

 

[gifariz]

Maybe:
Dim longArray(0, 1, 2, 3)

This will declare the dimension of variable instead (4-dimensional array with 0x1x2x3 size)

 

[Alex Blakenburg]

First and last example are taken from official microsoft documentation website [1] [2]

You will find that both your references relate to .NET

That syntax is not available in VBA.

The below is an extract from link [1] in your post.

 

[EXCEL MAX]

Maybe you looking for this...

Dim longArray: longArray = Array(0, 1, 2, 3, 4)

 

[Marc L]

First and last example are taken from official microsoft documentation website [1] [2]

Hi, as this is not the VBA documentation ‼ …​

​

So in VBA it needs at least two statements : one to declare the array variable, one to allocate the values :​

​

Dim V(): V = [{0,1,2,3,4,5}]​

 

[gifariz]

Thank you all for the answer