Thread
:
listbox click event question
View Single Post
#
4
Posted to microsoft.public.excel.programming
michdenis
external usenet poster
Posts: 135
listbox click event question
You could use a combobox or
If you want to use a listbox, you will be obliged to use
an other event such as these : ListBox1_DblClick_Change or
ListBox1_DblClick
For a reason i do not know, listbox1_click is not triggered when
Userform1 is activated a second time..
it works !
'-----------------------------
Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Me.Hide
Me.TextBox1.SetFocus
UserForm2.Show
End Sub
'-----------------------------
"Ken" a écrit dans le message de groupe de discussion :
...
That doesn't seem to help. When I get back to userform1, the click
event still doesn't fire when I click on the listbox. Also, now I
have to close the second userform twice before I get back to the first
userform; and I don't see the reason for that.
thanks
Ken
On Jan 11, 4:21 pm, "michdenis" wrote:
Hi,
try this :
Private Sub CommandButton1_Click()
Me.Hide
UserForm1.Show
Unload Me
End Sub
"Ken" a crit dans le message de groupe de discussion :
...
I am using Excel 2003. I have a two userforms, one with a listbox and
one with a commandbutton. The click event of the listbox on userform1
hides the userform1 and shows userform2. The commandbutton on
userform2 unloads userform2 and shows userform 1.
It works exactly as I want it for the first click of the listbox;
however, after the commandbutton on userform2 is clicedk to close
userform2 and show userform1, the click event on the listbox does not
fire.
This is initiating code
Sub test()
UserForm1.Show
End Sub
This is the code for the listbox
Private Sub ListBox1_Click()
Me.Hide
UserForm2.Show
End Sub
This is the code for the commandbutton
Private Sub CommandButton1_Click()
Unload Me
UserForm1.Show
End Sub
When I change it so userform1 is unloaded, not just hidden, it works
repetitively. I prefer not to unload userform1 because there is a
significant amount of data loaded and takes a few second each time.
Can anyone explain why this event is not triggered after the first
iteration of hiding and then redisplaying?
Thanks
Ken
Reply With Quote
michdenis
View Public Profile
Find all posts by michdenis