I want to trigger some event upon clicking certain options in listbox1. I can achieve this when listbox1 is set to SelectSingle. But when using fmMultiSelectMulti property, it does not work. Below is simple code I am using to test the clicking.
Private Sub ListBox1_Click()
If ListBox1.Selected(0) Then MsgBox "Nice"
End Sub
I click the first option and I thought it would trigger the MsgBox. Am I doing something wrong? How can I fix this?
Thanks
Edit: Using the change event worked!