View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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