listbox click event question

[Ken]

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

 

[michdenis]

Hi,

try this :

Private Sub CommandButton1_Click()
Me.Hide
UserForm1.Show
Unload Me
End Sub





"Ken" <[email protected]> a écrit dans le message de groupe de discussion :
(e-mail address removed)...
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

 

[Ken]

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

 

[michdenis]

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" <[email protected]> a écrit dans le message de groupe de discussion :
(e-mail address removed)...
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

 

[Ken]

I already use the double click event for some other functionality. I
guess I will have to come up with another work around; I'll probably
go back to unloading then reloading the form.

Thanks for you help.

Ken