View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Worksheet change event not firing

What did the dialog say?

Be aware your testing the Activesheet of THISWORKBOOK.
(that's the WB in which the form resides.)

That could very well be different from the Activesheet in the
Activeworkbook


Else just zip and email to addr below.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Wexler) wrote:

cool,
Thanks for your suggestion. I put a breakpoint in the worksheetchange
event handler sub, and when I type in the cell manually, it stops at
the breakpoint. When I use the form, it never hits the breakpoint.
The same sheet is always active when I use the form, and the value is
written to the sheet, but no event....
Any other ideas?

keepITcool wrote in message
. ..
put