How do you capture events?

[Scott buckwalter]

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?

[Gary's Student]

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?

[Bob Phillips]

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" <[email protected]> wrote in
message news:[email protected]...
> 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?