1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Private Sub ma_procedure()
Dim myRange As Excel.Range
Set myRange = ActiveWorkSheet.Range("E3")
If myRange.Value = "Valeur1" Then
change_valeur "pomme", "poire", "raisin"
ElseIf myRange.Value = "Valeur2" Then
change_valeur "pomme", "pomme", "poire"
ElseIf myRange.Value = "Valeur3" Then
' Et ainsi de suite...
End If
End Sub
Private Sub change_valeur(h3Valeur As String, _
i3Valeur As String, _
j3Valeur As String)
ActiveWorkSheet.Range("H3").Value = h3Valeur
ActiveWorkSheet.Range("I3").Value = i3Valeur
ActiveWorkSheet.Range("J3").Value = j3Valeur
End Sub |
Partager