Hi, Is that a way to out put the contents of an array of string using msgbox.
A AlEdlund Oct 2, 2009 #2 concatenate the array members as a string and then hand the string to msgbox. for intx = 1 to ubound(myarray) strX = strX & myarray(intx) next intx al
concatenate the array members as a string and then hand the string to msgbox. for intx = 1 to ubound(myarray) strX = strX & myarray(intx) next intx al
J John Goldsmith_Visio_MVP Oct 2, 2009 #3 You mean using VBA?.... Public Sub SendMessage() Dim arr As Variant arr = Array("This", "is", "an", "array") MsgBox (arr(0)) MsgBox (arr(1)) MsgBox (arr(2)) MsgBox (arr(3)) Dim myFullString As String myFullString = Join(arr) MsgBox (myFullString) End Sub Best regards John John Goldsmith (Visio MVP) www.visualSignals.typepad.co.uk www.visualSignals.co.uk
You mean using VBA?.... Public Sub SendMessage() Dim arr As Variant arr = Array("This", "is", "an", "array") MsgBox (arr(0)) MsgBox (arr(1)) MsgBox (arr(2)) MsgBox (arr(3)) Dim myFullString As String myFullString = Join(arr) MsgBox (myFullString) End Sub Best regards John John Goldsmith (Visio MVP) www.visualSignals.typepad.co.uk www.visualSignals.co.uk