/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

0 vote245 views1 answer
Excel web scraping
VBA
4 votes271 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote235 views1 answer
Ribbon show/hide
VBA
-1 vote244 views1 answer
Code for reading letters only in vb 6
VBA
1 vote248 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
1 vote227 views1 answer
How to put a gridpain in a vbox
VBA
0 vote217 views1 answer
Vba word pdf table to excel
VBA
0 vote220 views1 answer
Select case vba
VBA
0 vote232 views1 answer
Change form background image vb
VBA
0 vote222 views1 answer
Excel vba clear filter
VBA