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
|
Sub CreationCheckbox()
TableauNoms = Array("NomGenerique1", "NomGenerique2", "NomGenerique3", "NomGenerique4", "NomGenerique5")
Dim VariableOleObjet As OLEObject
i = 0
For Each NomVariable In TableauNoms
Set VariableOleObjet = ActiveSheet.OLEObjects.Add(ClassType:="Forms.CheckBox.1", Link:=False, _
DisplayAsIcon:=False, Left:=10, Top:=10 + 20 * i, Width:= _
108.103448275862, Height:=21.2068965517241)
VariableOleObjet.Name = TableauNoms(i)
i = i + 1
Next
End Sub
Sub EditionCheckbox()
TableauBox = Array(NomGenerique1, NomGenerique2, NomGenerique3, NomGenerique4, NomGenerique5)
i = 0
For Each NomBox In TableauBox
NomBox.Caption = "Intitulé générique" & i
i = i + 1
Next
End Sub
Sub CreationEditionCheckbox()
Call CreationCheckbox
Call EditionCheckbox
End Sub |
Partager