1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| Sub CreationMD1(control As IRibbonControl, ByRef Content)
Dim Col, Lig As Variant
'ouverture de la balise menu
Content = "<menu xmlns=""http://schemas.microsoft.com/office/2006/01/customui"">"
For Col = 2 To 4 Step 1
'Création du menu en fonction du "titre" de la ligne
Content = Content & "<menu " & _
CreationAttribut("id", "BtFA1" & Col) & " " & _
CreationAttribut("label", Cells(1, Col).Value) & " " & _
CreationAttribut("tag", Cells(1, Col).Value) & ">"
For Lig = 2 To 5
'Création des boutons de chaque colonne
Content = Content & "<button " & _
CreationAttribut("id", "BtFA" & Lig & Col) & " " & _
CreationAttribut("label", Cells(Lig, Col).Value) & " " & _
CreationAttribut("tag", Cells(Lig, Col).Value) & " " & _
CreationAttribut("onAction", "AjoutDonneesFA") & "/>"
Next Lig
'fermeture de la balise
Content = Content & "</menu>"
Next Col
'fermeture du menu principal
Content = Content & "</menu>"
End Sub |
Partager