Cannot initialize the value of an array in VBA

Question

I am still new to VBA. here is the code:

Sub Macro1()
Dim NumberSeq() As Integer = {1,2,3,4}
End Sub

It's just the initialization of an array and I saw it work for others. But I always get the warning window: Compile error: Expected: end of statement with highlight on the equal mark"="

Don't know what happened here. Please advice, thank you a lot!!

Closest you could get might be Dim a(): a = [{1,2,3}] - but note that's a variant array not an integer one — Tim Williams
– Tim Williams, Commented Jun 17, 2013 at 21:59

Community · Accepted Answer · 2018-05-08 21:48:18Z

2

Sub macro1()
Dim NumberSeq() As Variant

NumberSeq = Array(1, 2, 3, 4) 'an allocated array with length 1 to 4

'check output through print
For i = LBound(NumberSeq) To UBound(NumberSeq)
    msg = msg & NumberSeq(i) & vbNewLine
Next i
MsgBox (msg)

End Sub

For implicitly sized 2 dimensional arrays use Array(row start To row end, col start to col end).

Here is a good resource.

edited May 8, 2018 at 21:48

CommunityBot

11 silver badge

answered Jun 17, 2013 at 21:55

agconti

18.2k17 gold badges85 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2495069 Over a year ago

Thank you so much for both of your help! It works! It seems without the "As Variant" also works. And thank you for sharing the website resource:)

agconti Over a year ago

No problem! there is a lot of great information there. If I answered your question please click the check mark next to my answer, thanks!

Collectives™ on Stack Overflow

Cannot initialize the value of an array in VBA

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related