How to use arrays in VBA

jbburf · October 4th, 2012, 09:20 PM

Hi,

I am trying to dim a constant array with values and then use it later in the VBA code.

My current code (after many iterations of trial and error) is:

Code:

Dim document_type(1 To 6) As String
document_type = Array("PRF", "SRF", "SBF", "ASF", "NPR", "ASR")

I am using Option Explicit. I am using Excel 2010. Any help is greatly appreciated!

Shasur · October 7th, 2012, 01:21 PM

Hi

This code looks good.

Please let us know your requirement

Cheers
Shasur

jbburf · October 8th, 2012, 01:44 PM

The above code won't work. I've found a workaround by using:

Code:

    Dim document_type(1 To 6) As String
    document_type(1) = "PRF"
    document_type(2) = "SRF"
    document_type(3) = "SBF"
    document_type(4) = "ASF"
    document_type(5) = "NPR"
    document_type(6) = "ASR"

But there must be a way to dim the array in one statement without having to set each part individually.