Proper way to fire events

Mar 12th, 2002, 08:51 PM

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 · Mar 12th, 2002, 08:55 PM

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 TakeFocus******* 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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 08:51 PM	#1
Guest Posts: n/a	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?

Mar 12th, 2002, 08:55 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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 TakeFocus******* 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 ]