Hi -

Does anyone know, is there any way to trap a select or activate event for a
cell in a worksheet ? My code generates statistical analysis on columns of
data and it would be nice to be able to highlight the source data involved
whenever I click in one of the result cells. Any ideas anyone ?

Thanks

The SelectionChange event fires whenever you select a cell. You
can test the Target parameter to see if it is one of your cells,
and act accordingly.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tim Jarrett" <Tim wrote in
message
...
Hi -

Does anyone know, is there any way to trap a select or activate
event for a
cell in a worksheet ? My code generates statistical analysis
on columns of
data and it would be nice to be able to highlight the source
data involved
whenever I click in one of the result cells. Any ideas anyone
?

Thanks