listbox comparaison

[Mundis06]

hello everyone , I have a project I 'm doing for my university which consists of having an excel document that is full of computing , I m stucked at this point where i want to have 2 list box in a sheet that shows many of the items and when you compare two items i want the sheet to show in 2 others cell sheet the numeric result value that is calculated in another sheet and the value appear only after the selection of the second item.

[6StringJazzer]

Here is one way to take action once an item has been selected from each list, but you haven't explained how to do the comparison or where the results go.

Private Sub ListBox1_Click()
   Compare
End Sub

Private Sub ListBox2_Click()
   Compare
End Sub

Private Sub Compare()

   If Me.ListBox1.ListIndex >= 0 And _
      Me.ListBox2.ListIndex >= 0 Then
      
      ' compare two items i want the sheet to show in 2 others cell sheet
      ' the numeric result value that is calculated in another sheet
   
      ' Remove current choices
      Me.ListBox1.ListIndex = -1
      Me.ListBox2.ListIndex = -1
      
   End If

End Sub

[Mundis06]

Thanks 6StringJazzer , the result should appears on the same sheet where i do have the list-boxes
.

[6StringJazzer]

If my code doesn't give you what you need then you are going to have to describe your problem in much more detail.