Access manually added ListBox in VBE

once you add the listbox right click it and choose View Code. you can then use the dropdown on the left of the module window to select Listbox1 and the dropdown on the right lists all the available events. you can also right click the control and choose Properties to set design time properties such as the listfillrange

my bad-didn't notice you were on a mac so you aren't using an activex listbox and can't access its properties in the vbe
you can refer to it using

Please Login or Register  to view this content.

note that it does not have a Text property-you have to use Value or Listindex both of which return the position of the selected item in the list starting at 0 for the first item

Finally! Wow this helps SO MUCH! Thank you!
I'm kind of using different computers on and off, one being a mac and one being a pc, is it easier to work with a activex listbox? Can I use the "Text" function with a activex listbox? (Don't have access to the pc atm, so can't try it myself)
Having some issues with working with the listbox in the sheet, can't get it to work as my userform listboxes.. I just want to perform some actions based on what's highlighted in the listbox. How do i write a macro that reacts to "clicks" when it's not in a userform? messed around a bit:

Please Login or Register  to view this content.

But that wouldn't work. How does it work?

you assign a macro to the listbox but note what I said before: you have to use Value or Listindex both of which return the position of the selected item in the list starting at 0 for the first item

if TEST is the first item then

Please Login or Register  to view this content.

you're welcome :-)