View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jussi Peltonen Jussi Peltonen is offline
external usenet poster
 
Posts: 2
Default Events with cell link


It seems to me that the following KB article applies also dialog
objects on a worksheet.

http://support.microsoft.com/default...b;en-us;213715



On Wed, 15 Oct 2003 06:13:23 GMT, (Jussi
Peltonen) wrote:

Hi!

I've been using SheetCalculate and SheetChange events of the
Application object to detect changes on a worksheet.

Now I added a check box on the worksheet and linked it to a cell. When
I check/uncheck the check box I can see TRUE/FALSE values in that
particular cell but neither the SheetCalculate nor the SheetChange
event is fired. Why?

How can I fire an event in the situation described above?

Thanks,
Jussi