Hi Mike,
Since your specific interest at the moment is in Event macros

Event Macros, Worksheet Events and Workbook Events
http://www.mvps.org/dmcritchie/excel/event.htm

Application Events (Chip Pearson)
http://www.cpearson.com/excel/AppEvent.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tinkerbellsmyhoe" wrote in message oups.com...
Man. is there a good complete (CONSISE) book or online reference for
this stuff? this whole time i was trying to use cell.value instead of
target.value. i also tried target.cell and both were incorrect.

I appreciate your help so far....greatly!

thanks,
Mike