Thread: VBScript Event Sink Not Firing
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robert Bruce Robert Bruce is offline
external usenet poster
  
Posts: 16
Default VBScript Event Sink Not Firing
Yn newyddion: ,
Roedd Alex Turner wedi ysgrifennu:

Anyone knows why this does not work - i.e. the even sink
excel_SheetChange never fires?


VBScript supports only late binding. In order to sink COM events you need to
early bind and use the WithEvents declaration in a class module.

Rob

Reply With QuoteReply With Quote