Please help.
I have a spreasheet with a command button opeing a userform, on the user form you select from a listbox and the value is entered into cell E3 and the userform closes.
However about 50% of the time the value entered in cell E3 disappears and also from then on if you type in cell E3 when you press enter the text just deletes itself.
The code i use is below:
Private Sub CommandButton1_Click()
UserForm1.Hide
End Sub
Private Sub UserForm_Initialize()
Dim Advisor As Variant
Dim Date1 As Variant
Advisor = Array("XXXX", "XXXX")
UserForm1.ListBox1.List = Advisor
'information contained date in list box
Date1 = Array("January 2006", "February 2006", "March 2006", "April 2006", "May 2006", _
"June 2006", "July 2006", "August 2006", "September 2006", "October 2006", _
"November 2006", "December 2006")
UserForm1.ListBox2.List = Date1
End Sub
I hope someone has heard of this problem. Not sure if there are property settings that would make this happen. (not that i have changed any i dont know)
Regards
I have a spreasheet with a command button opeing a userform, on the user form you select from a listbox and the value is entered into cell E3 and the userform closes.
However about 50% of the time the value entered in cell E3 disappears and also from then on if you type in cell E3 when you press enter the text just deletes itself.
The code i use is below:
Private Sub CommandButton1_Click()
UserForm1.Hide
End Sub
Private Sub UserForm_Initialize()
Dim Advisor As Variant
Dim Date1 As Variant
Advisor = Array("XXXX", "XXXX")
UserForm1.ListBox1.List = Advisor
'information contained date in list box
Date1 = Array("January 2006", "February 2006", "March 2006", "April 2006", "May 2006", _
"June 2006", "July 2006", "August 2006", "September 2006", "October 2006", _
"November 2006", "December 2006")
UserForm1.ListBox2.List = Date1
End Sub
I hope someone has heard of this problem. Not sure if there are property settings that would make this happen. (not that i have changed any i dont know)
Regards