How to declare literal array in VBA

[MattLewis]

I can't figure out how to declare a literal array in VBA. According to MSDN documentation, it should be:

Dim numbers = New Integer() {1, 2, 4, 8}

But that's giving me an error that says "Compile error: Expected: end of statement at the "=" sign.

I'm thinking that I might be looking at the wrong "Visual Basic" in MSDN, so if someone has an object reference for the VBA that's in Access specifically, that would help. Google keeps giving me......something else.

[MattLewis]

I ended up using the Array function.

Dim numbers() as Integer
Numbers = Array(1, 2,4, 8)

That's just cheesy if that's how VB does arrays