Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display an array in a MsgBox
Excel XP & Win XP
I have a variable array that could be ShtArray(a,b,c) or ShtArray(d,e,f,g,h), etc. The number of elements in the array is also a variable, as you can see. In proofing my code I want to find out what array the code selected, so I used: MsgBox "ShtArray is: " & ShtArray which errored out with a "Type Mismatch". What code would I use to see the elements of the selected array? I just want to see them at this point. I don't want to do anything with them. Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display an array in a MsgBox
Hi Otto
You have to create a string with all elements from the array: Dim MsgString As String For i = LBound(ShtArray) To UBound(ShtArray) If MsgString = "" Then MsgString = ShtArray(i) Else MsgString = MsgString & ", " & ShtArray(i) End If Next msg = MsgBox("ShtArray is: " & MsgString) Regards, Per "Otto Moehrbach" skrev i meddelelsen ... Excel XP & Win XP I have a variable array that could be ShtArray(a,b,c) or ShtArray(d,e,f,g,h), etc. The number of elements in the array is also a variable, as you can see. In proofing my code I want to find out what array the code selected, so I used: MsgBox "ShtArray is: " & ShtArray which errored out with a "Type Mismatch". What code would I use to see the elements of the selected array? I just want to see them at this point. I don't want to do anything with them. Thanks for your time. Otto |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display an array in a MsgBox
Thank you very much for that. Otto
"Per Jessen" wrote in message ... Hi Otto You have to create a string with all elements from the array: Dim MsgString As String For i = LBound(ShtArray) To UBound(ShtArray) If MsgString = "" Then MsgString = ShtArray(i) Else MsgString = MsgString & ", " & ShtArray(i) End If Next msg = MsgBox("ShtArray is: " & MsgString) Regards, Per "Otto Moehrbach" skrev i meddelelsen ... Excel XP & Win XP I have a variable array that could be ShtArray(a,b,c) or ShtArray(d,e,f,g,h), etc. The number of elements in the array is also a variable, as you can see. In proofing my code I want to find out what array the code selected, so I used: MsgBox "ShtArray is: " & ShtArray which errored out with a "Type Mismatch". What code would I use to see the elements of the selected array? I just want to see them at this point. I don't want to do anything with them. Thanks for your time. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
Display Totals In MsgBox | Excel Programming | |||
display msgbox in order or one after the other | Excel Programming | |||
MsgBox Display | Excel Programming | |||
Display of $ in Msgbox | Excel Programming |