Display table in MsgBox VBA excel
redyou
-
EnPanik!! -
EnPanik!! -
Hello,
SOS, I need to display the elements of an array Tab(i) where i corresponds to the row number, in a MsgBox
as long as i is not equal to 1 I display the content of the cell ("A" i) and move to the next line.
Thank you in advance for your help, it's urgent
SOS, I need to display the elements of an array Tab(i) where i corresponds to the row number, in a MsgBox
as long as i is not equal to 1 I display the content of the cell ("A" i) and move to the next line.
Thank you in advance for your help, it's urgent
Configuration: Windows XP Mozilla 1.7.3
6 réponses
Hello,
Typical example:
Lupin
Typical example:
Option Explicit Sub DisplayTable() Dim Table(1 To 10) As String Dim strMessage As String, Loop As Integer Table(1) = "France" Table(2) = "Spain" Table(3) = "Italy" Table(4) = "China" Table(5) = "Portugal" Table(6) = "Canada" Table(7) = "Brazil" Table(8) = "Argentina" Table(9) = "Venezuela" Table(10) = "Australia" strMessage = "" For Loop = 1 To 10 strMessage = strMessage & Table(Loop) & vbLf Next Loop MsgBox strMessage End Sub '
Lupin