He's not using VB6 at all, but instead using Excel only. Excel listboxes default to the name ListBox1 instead of List1, and in Excel the default event is ListBox1_Change(), which doesn't exist in VB6.

I'm wondering how he "floats" his listbox between sheets. Doesn't it disappear when you click an item that sends you to a different sheet?