Guest User

Untitled

a guest
May 28th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.28 KB | None | 0 0
  1. COMBOBOX
  2. 'combobox Pastille
  3. For i = 2 To 10
  4. cmbPastille.AddItem (sheetFormat.Cells(i, 3).Value)
  5. Next
  6.  
  7. ACTU IMAGE PASTILLE
  8. Private Sub cmbPastille_Change()
  9. Dim chemin As String: chemin = ThisWorkbook.Path & "\Images\Pastilles\"
  10. Select Case cmbPastille.Value
  11. Case "Fruité et léger"
  12. imgPastille.Picture = LoadPicture(chemin & "fruiteLeger.jpg")
  13. Case "Fruité et généreux"
  14. imgPastille.Picture = LoadPicture(chemin & "fruiteGenereux.jpg")
  15. Case "Aromatique et souple"
  16. imgPastille.Picture = LoadPicture(chemin & "aromeSouple.jpg")
  17. Case "Aromatique et charnu"
  18. imgPastille.Picture = LoadPicture(chemin & "aromeCharnu.jpg")
  19. Case "Délicat et léger"
  20. imgPastille.Picture = LoadPicture(chemin & "delicatLeger.jpg")
  21. Case "Fruité et vif"
  22. imgPastille.Picture = LoadPicture(chemin & "fruiteVif.jpg")
  23. Case "Aromatique et rond"
  24. imgPastille.Picture = LoadPicture(chemin & "aromeRond.jpg")
  25. Case "Fruité et doux"
  26. imgPastille.Picture = LoadPicture(chemin & "fruiteDoux.jpg")
  27. Case "Fruité et extra-doux"
  28. imgPastille.Picture = LoadPicture(chemin & "fruiteExtraDoux.jpg")
  29. End Select
  30. UserForm1.Repaint
  31. End Sub
Add Comment
Please, Sign In to add comment