Thread: form problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default form problem

Perhaps you have event code associated with the listboxes which is being
fired.

--
Regards,
Tom Ogilvy


"inquirer" wrote in message
...
I have this as part of a form. When I run the form from a program, if I

just
accept the form defaults, the value for listbox2 is "LIVE" and listbox3 is
"".
In the Tab Order for the form, Listbox 2 is above Listbox3.
If I change this order in the Tab Order then in the program, listbox2 is

""
and listbox3 is "LONG".
Can anyone tell me what is causing this behaviour please? I want both
listboxes to contain the default values when the form is exited.

I am using excel xp

Thanks

Chris

Private Sub UserForm_initialize()
Dim d1 As String
TextBox1.Value = 30
TextBox4.Value = 90
TextBox18.Value = 20
TextBox24.Value = 30
ListBox2.AddItem "LIVE"
ListBox2.AddItem "BACKTEST"
ListBox2.ListIndex = 0
ListBox3.AddItem "LONG"
ListBox3.AddItem "SHORT"
ListBox3.ListIndex = 0
TextBox3.Visible = False
TextBox10.Visible = False
TextBox27.Visible = False
Label32.Visible = False
Label6.Visible = False
ListBox2.Value = "LIVE"
ListBox3.Value = "LONG"

End Sub