MsgBox &array

A

AlEdlund

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top