Ok, ive tried everything i can think of but i just cant get it to
work, i want to load an array of data into a list box when a form
opens.

eg: Private Sub UserForm_initialize()
With ListMonth
..AddItem "July"
..AddItem "August"
..AddItem "September"
..AddItem "October"
..AddItem "Novemebr"
..AddItem "December"
..AddItem "Janurary"
..AddItem "February"
..AddItem "March"
..AddItem "April"
..AddItem "May"
..AddItem "June"
End With
End Sub

but this doesnt seem to work, i can hook the sub up to a button and
make it work, but i just want it to happen on opening the form?

how do i do this?