Private Sub ComboBox1_Click() On Error Resume Next Dim img As String img = ComboBox1.Value Feuil1.Image1.Picture = LoadPicture(ActiveWorkbook.Path & "" & img & ".jpg") End Sub
Private Sub ComboBox1_Click() On Error Resume Next Dim img As String img = ComboBox1.Value Feuil2.ComboBox1.ListIndex = ComboBox1.ListIndex 'on nomme la feuille2 car nous sommes sur la feuille1 Image1.Picture = LoadPicture(ActiveWorkbook.Path & "" & img & ".jpg") End Sub
Private Sub ComboBox1_Change() On Error Resume Next Dim img As String img = ComboBox1.Value Image1.Picture = LoadPicture(ActiveWorkbook.Path & "" & img & ".jpg") End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub ComboBox1_Click() On Error Resume Next Dim img As String img = ComboBox1.Value Feuil1.Image1.Picture = LoadPicture(ActiveWorkbook.Path & "" & img & ".jpg") Feuil2.Image1.Picture = LoadPicture(ActiveWorkbook.Path & "" & img & ".jpg") End Sub