Hi,

I'm trying to simply create a listbox by Developer > Insert > ListBox and then I want to access said listbox through the VBE to perform actions on it. How do I initialize the listbox from VBE? I don't want to select a range to fill the list. And even if i do, where do i put my code that tells the listbox to perform actions based what is beeing highlighted?

I've tried this (in my Module1):
Sub ListBox1_change()
    If ListBox1.Text = "Test" Then
       Call MyMacro
    End If
End Sub
But this gives me the "object required error".

Thanks for any help!