Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following simple program is supposed to display one message box
containing the string "Jan", and a second one containing six month names separated by dashes. At least one person reports getting this result from the code, but when I run it on my two laptop computers, the first message box is empty, and the second contains only the five dashes (no month names). All of these are Windows XP PCs running Excel 2003. Any suggestions as to why this is happening will be greatly appreciated. Option Base 1 Dim Arr() As String Sub assignArray() ReDim Arr(5) Arr(1) = Jan Arr(2) = Feb Arr(3) = Mar Arr(4) = Apr Arr(5) = May MsgBox Arr(1) ReDim Preserve Arr(6) Arr(6) = Jun MsgBox Arr(1) + "-" + Arr(2) + "-" + Arr(3) + "-" + Arr(4) + "-" + Arr(5) + "-" + Arr(6) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula only works on some computers | Excel Worksheet Functions | |||
Macro works differently on different computers, same version of Ex | Excel Discussion (Misc queries) | |||
setfocus on control works on some computers and not others | Excel Programming | |||
Why won't this code works | Excel Programming | |||
How can I distribute Workbook with VBA code and library references to other computers | Excel Programming |