How do you capture events?
 

Ok, I'm missing something here. I've tried copying events from posts, help
files, having VB create them but they do not work. I cannot get an event to
fire. Can someone tell me how to get any event to fire?

Specifically, how do you add event handling to a set of macros?

How do you capture events?
 

Please read:

http://cpearson.com/excel/events.htm

very carefully. Of critical importance is where the macros are stored -
modules, worksheet code, etc. If you put them in the wrong place, they won't
work.
--
Gary's Student


"Scott buckwalter" wrote:

Ok, I'm missing something here. I've tried copying events from posts, help
files, having VB create them but they do not work. I cannot get an event to
fire. Can someone tell me how to get any event to fire?

Specifically, how do you add event handling to a set of macros?

How do you capture events?
 

Are you storing them in the correct place?

Try this simple one


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox "hello"
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Scott buckwalter" wrote in
message ...
Ok, I'm missing something here. I've tried copying events from posts, help
files, having VB create them but they do not work. I cannot get an event
to
fire. Can someone tell me how to get any event to fire?

Specifically, how do you add event handling to a set of macros?