View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default Running a macro on action

To access the events that are generated on a sheet do this...

Right Click the tab of the sheet - Select View Code
Just above the code window you will see the word general
Change General to Worksheet

Just to the right of Worksheet is a drop down list of all of the events that
you can make your code respond to. Note that when you select the event a code
procedure is created for you automatically... Easy as that. Some of the
procedures will have arguments like Target. Target is the cell you just
changed or selected or...

HTH

"Andrew" wrote:

Hi,

This is probably a simple one but I just cant find the answer. How does one
kick off a macro by a specific cell being altered (eg data keyed into it,
change of font etc)

--
Andrew