excelvbaで配列の文字列をMsgBoxで表示する

Join()使えば一発。

Dim arr(1 To 3) As String

 arr(1) = "東京"
 arr(2) = "大阪"
 arr(3) = "名古屋"

 MsgBox Join(arr)