Proper way to fire events

[Guest]

Hi,
I have a ListBox1 that responds to a click event by running function ListBox1_Click().

I have a CommandButton1 that responds to a click event by running function CommandButton1_Click()

I want, by clicking CommandButton1, a Click event for ListBox1 to be fired. Did this..

Sub CommandButton1_Click()
ListBox1_Click
End Sub

kinda works.. but Excel's displaying the sheets all wrong now.. ie its not cleared
Tried RaiseEvent, but that does not work

Question: How do I correctly fire an event?

 

[Dave Hawley]

I have no real idea of what your problems are as you haven't really told us, other than "Excel's displaying the sheets all wrong "

Try setting the TakeFocusOnClick property for the CommandButton to False.



_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

This message was edited by Dave Hawley on 2002-03-12 19:56