Check contents of array

[SharkDesign]

I can add things to an array, but for debugging I'd like to sometimes be able to see what this actually contains, is there a way to do this, or export a txt file or something?

iLogic

[bradeneuropeArthur]

for vba?

[SharkDesign]

No, iLogic. I tried to put a space after the word iLogic above but it wouldn't let me edit the post.

The only way I've managed to do it so far is to loop through the array and send each value to the logger, but this seemed a bit long winded. 

[bradeneuropeArthur]

https://adndevblog.typepad.com/manufacturing/2014/08/debug-ilogic.html 

[SharkDesign]

I know how to debug, my question was, what is the easiest way to view the contents of an array. 

[bradeneuropeArthur]

Public Sub main()

Dim a As Variant
a = Array(1, 2, 3)
'MsgBox a(1)
MsgBox Join(a, vbCrLf)
End Sub

[bradeneuropeArthur]

or this:

Public Sub Main()

Dim a() As String
a = {"1", "2", "3"}

MsgBox (Join(a, vbCrLf))
End Sub