/VBA/Label de tableau dans des label.text en VBA

Label de tableau dans des label.text en VBA

Sub tableaux()
 Dim tableauLabel As Label(,) = {{Label1, Label2, Label3}, {Label4, Label5, Label6}, {Label7, Label8, Label9}}
 ' il y avait une virgule en trop entre les deux dernières accolades
 Dim TA(,) As String = New String(2, 2) {{"A", "B", "C"}, {"a", "b", "c"}, {"c", "d", "e"}}
 Dim i As Long
 Dim j As Long
 For i = 0 To 2
  For j = 0 To 2
  tableauLabel(i, j).Text = TA(i, j)
  Next j
 Next i
End Sub

Source: social.msdn.microsoft.com

Similar codes

1 vote1.1K views1 answer
Vba Remove Case Sensitivity
VBA
1 vote170 views1 answer
Excel vba unload userform
VBA
5 votes182 views1 answer
Excel vba right word from Long Integer
VBA
3 votes185 views1 answer
Excel vba get the workbook full filename with path
VBA
27 votes309 views2 answers
Vba check if file exists
VBA
0 vote126 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote159 views1 answer
Vba copy paste value only
VBA
1 vote180 views1 answer
Vba optional
VBA
0 vote243 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote181 views1 answer
Excel vba open browser
VBA