Bonjour,
ceci peut être :
Private Sub CommandButton1_Click()
'bouton chercher
Dim code As Integer
Dim desi As Integer
Dim sLstcode As String
Dim sLstdesi As String
With Worksheets("feuil1")
For code = 2 To 50
If .Cells(code, 3) <> 0 Then
sLstcode = sLstcode & vbCrLf & .Cells(code, 1) & " - " & .Cells(code, 2)
End If
Next code
' For desi = 2 To 50
' If .Cells(desi, 3) <> 0 Then
' sLstdesi = sLstdesi & vbCrLf & .Cells(desi, 2)
' End If
' Next desi
End With
MsgBox ("les codes et les désignations sont:" & sLstcode & sLstdesi)
End Sub