How are you!
I got stuck when making the following macro.
Here is a piece of the code I'm trying to use.
If ListBox1.Selected(0) = True Then
Call b7
If ListBox1.Selected(1) = True Then
Call b8
If ListBox1.Selected(2) = True Then
Call b9
End If
End If
End If
End Sub
Basically I need the macro to call the appropriate Subs if the listbox items are selected.
The trouble I'm having is that if only listbox(0) and listbox(2) are selected, only b7 is called and not b9.
How can make VBA call whatever appropriate sub based on whichever corresponding lisbox entry is selected.
Thank you
Bookmarks