Hi Paul and Mikerickson,
Thanks for both of your replies. Looks like i am going to have to rewrite parts of my application to remove .Value!
I think this behaviour is something to do with the item not being selected despite using .ListIndex because if i run this code:
Private Sub UserForm_Initialize()
ListBox1.AddItem "bob"
ListBox1.AddItem "bill"
ListBox1.ListIndex = 1
ListBox2.AddItem "Frank"
ListBox2.AddItem "Harry"
ListBox2.ListIndex = 1
End Sub
Private Sub UserForm_Click()
Box1Val = ListBox1.Value
Box2Val = ListBox2.Value
End Sub
Userform1 initialises - then click on "Harry" in ListBox2 and then on the userform to activate UserForm_Click() both Box1Val and Box2Val return the expected values.....It seems to me that on initialisation ListIndex is only selecting the item in Listbox1 and ignoring Listbox2 until physically clicked by the user....
EDIT - Actually you dont even need to click on "Harry". Just initialising and then clicking on the userform seems to work!
Thanks
Matt