I am wondering how you can select by default an item of the listbox. eg. actual.

  Sheet1.ListBox1.AddItem "(All)"
  Sheet1.ListBox1.AddItem "Actual"
I have tried

Sheet1.ListBox1.ListIndex = 0
Sheet1.ListBox1.Select