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
| Option Explicit
Dim S As Object
Dim tl(FORMULALOC, 1) As String
Dim CbLoco As ComboBox
Sub userform_initialize()
With feuil1
Set S = .DropDowns.Add(.Cells(14, 2).Left, .Cells(14, 2).Top, .Range(Cells(14, 2), _
Cells(14, 3)).Width, .Cells(14, 2).Height)
End With
tl(0, 0) = "Générale SNCF"
tl(0, 1) = "0.65*L+13*n+0.01*L*V+0.03*V^2"
tl(1, 0) = "DB BR201"
tl(1, 1) = "0,96+3.83*((V+20)/100)^2"
tl(2, 0) = "DB BR211"
tl(2, 1) = "1.37+4.95*(V/100)^2"
tl(3, 0) = "DB BR212"
tl(3, 1) = "1.39+4.95*(V/100)^2"
tl(4, 0) = "DB BR215"
tl(4, 1) = "2.80+3.48*(V/100)^2"
S.Select
S.Name = "CbLoco"
S.List = Array(tl(0, 0), tl(1, 0), tl(2, 0), tl(3, 0), tl(4, 0))
End Sub |
Partager