I'm confused, what exactly do you need?

Only you know the possible values in your listbox. So only you can complete the code.

ListBox.Value gives you the selected value. Just plug that into your Select Case Statement. Something like this:

[VBA]
Select Case ListBox.Value
Case "apples"
' do something if "apples" is selected
Case "oranges"
' do something if "oranges" is selected
End Select
[/VBA]