Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorpoarting cell contents into a message box | Excel Discussion (Misc queries) | |||
Printing All the Contents of a Cell | Excel Worksheet Functions | |||
Printing contents of a listbox | Excel Programming | |||
copy and paste and clipboard contents message | Excel Programming | |||
Printing with a message | Excel Programming |