Printing contents of an array into a message box
 

Hi,

Currently, I am working through some basic examples given on this
website: http://www.anthony-vba.kefra.com/index_011.htm. When I tried
the first example in Excel VBA Basic Tutorial 3, ie:


Option Base 1
Sub assignArray( )
Dim Arr(5)


Arr(1) = "Jan"
Arr(2) = "Feb"
Arr(3) = "Mar"
Arr(4) = "Apr"
Arr(5) = "May"


Msgbox Arr(1) & "-" & Arr(2) & "-" & Arr(3) & "-" &
Arr(4) & "-" & Arr(5)
End Sub


I ended up with: ---- in the message box, rather than: Jan-Feb-
Mar-Apr-May


What do I need to do in order to correct this?


Cheers,


Alex

Printing contents of an array into a message box
 

I copied and pasted into the code window. Fixed the line wrap problem and ran
your code.

It worked fine.

Maybe this isn't the same code that failed???

Alex_Rodriguez wrote:

Hi,

Currently, I am working through some basic examples given on this
website: http://www.anthony-vba.kefra.com/index_011.htm. When I tried
the first example in Excel VBA Basic Tutorial 3, ie:

Option Base 1
Sub assignArray( )
Dim Arr(5)

Arr(1) = "Jan"
Arr(2) = "Feb"
Arr(3) = "Mar"
Arr(4) = "Apr"
Arr(5) = "May"

Msgbox Arr(1) & "-" & Arr(2) & "-" & Arr(3) & "-" &
Arr(4) & "-" & Arr(5)
End Sub

I ended up with: ---- in the message box, rather than: Jan-Feb-
Mar-Apr-May

What do I need to do in order to correct this?

Cheers,

Alex

--

Dave Peterson