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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
| Option Explicit
Option Base 1
Public Const NBLANG As Integer = 3
Sub Langue()
Dim Montableau(20, NBLANG) As String
Montableau(1, 1) = "Langue"
Montableau(1, 2) = "Language"
Montableau(1, 3) = "Sprache"
Montableau(2, 1) = "Projet"
Montableau(2, 2) = "Project"
Montableau(2, 3) = "Projekt"
Montableau(3, 1) = "Nom"
Montableau(3, 2) = "Name"
Montableau(3, 3) = "Name"
Montableau(4, 1) = "Date"
Montableau(4, 2) = "Date"
Montableau(4, 3) = "Datum"
Montableau(5, 1) = "Auteur"
Montableau(5, 2) = "Author"
Montableau(5, 3) = "Autor"
Montableau(6, 1) = "Commentaire"
Montableau(6, 2) = "Comment"
Montableau(6, 3) = "Kommentar"
Montableau(7, 1) = "Locomotive"
Montableau(7, 2) = "Locomotive"
Montableau(7, 3) = "Lokomotive"
Montableau(8, 1) = "Nom"
Montableau(8, 2) = "Name"
Montableau(8, 3) = "Name"
Montableau(9, 1) = "Poids"
Montableau(9, 2) = "Weight"
Montableau(9, 3) = "Masse"
Montableau(10, 1) = "Formule"
Montableau(10, 2) = "Formula"
Montableau(10, 3) = "Formel"
Montableau(11, 1) = "Nombre d'essieux moteurs"
Montableau(11, 2) = "Number of motorised axles"
Montableau(11, 3) = "Anzahl von angetriebene Radsätze"
Montableau(12, 1) = "Nombre total d'essieux"
Montableau(12, 2) = "Total number of axles"
Montableau(12, 3) = "Anzahl von Radsätze"
Montableau(13, 1) = "Batterie"
Montableau(13, 2) = "Battery"
Montableau(13, 3) = "Batterie"
Montableau(14, 1) = "Nom"
Montableau(14, 2) = "Name"
Montableau(14, 3) = "Name"
Montableau(15, 1) = "Nombre de cellules"
Montableau(15, 2) = "Number of cells"
Montableau(15, 3) = "Anzahl der Zellen"
Montableau(16, 1) = "Tension par cellule"
Montableau(16, 2) = "Cell's tension"
Montableau(16, 3) = "Spannung der Zelle"
Montableau(17, 1) = "Energie par cellule"
Montableau(17, 2) = "Cell's energy"
Montableau(17, 3) = "Energie der Zelle"
Montableau(18, 1) = "Generateur"
Montableau(18, 2) = "Generator set"
Montableau(18, 3) = "Generator set"
Montableau(19, 1) = "Nom"
Montableau(19, 2) = "Name"
Montableau(19, 3) = "Name"
Montableau(20, 1) = "Puissance nominale"
Montableau(20, 2) = "Nominal Power"
Montableau(20, 3) = "Nominale Leistung"
If Feuil1.Langage.Value = "Français" Then
Feuil1.Cells(3, 1) = Montableau(1, 1)
Feuil1.Cells(5, 1) = Montableau(2, 1)
Feuil1.Cells(6, 1) = Montableau(3, 1)
Feuil1.Cells(7, 1) = Montableau(4, 1)
Feuil1.Cells(8, 1) = Montableau(5, 1)
Feuil1.Cells(9, 1) = Montableau(6, 1)
Feuil1.Cells(11, 1) = Montableau(7, 1)
Feuil1.Cells(12, 1) = Montableau(8, 1)
Feuil1.Cells(13, 1) = Montableau(9, 1)
Feuil1.Cells(14, 1) = Montableau(10, 1)
Feuil1.Cells(15, 1) = Montableau(11, 1)
Feuil1.Cells(16, 1) = Montableau(12, 1)
Feuil1.Cells(18, 1) = Montableau(13, 1)
Feuil1.Cells(19, 1) = Montableau(14, 1)
Feuil1.Cells(20, 1) = Montableau(15, 1)
Feuil1.Cells(21, 1) = Montableau(16, 1)
Feuil1.Cells(22, 1) = Montableau(17, 1)
Feuil1.Cells(24, 1) = Montableau(18, 1)
Feuil1.Cells(25, 1) = Montableau(19, 1)
Feuil1.Cells(26, 1) = Montableau(20, 1)
ElseIf Feuil1.Langage.Value = "English" Then
Feuil1.Cells(3, 1) = Montableau(1, 2)
Feuil1.Cells(5, 1) = Montableau(2, 2)
Feuil1.Cells(6, 1) = Montableau(3, 2)
Feuil1.Cells(7, 1) = Montableau(4, 2)
ElseIf Feuil1.Langage.Value = "Deutsch" Then
Feuil1.Cells(3, 1) = Montableau(1, 3)
Feuil1.Cells(5, 1) = Montableau(2, 3)
Feuil1.Cells(6, 1) = Montableau(3, 3)
Feuil1.Cells(7, 1) = Montableau(4, 3)
End If
End Sub |
Partager