Automation Events
Excel has several events; I use the one that I have referred to earlier, SheetSelectionChange.
I want to be able to say:
xl.SheetSelectionChange = "Newx" i.e set the SheetSelectionChange event to run the sub "Newx"; it should be trigerred when I execute xl.Cells(1,2).Select i.e change the selection.
Thsi is a trivial example: the principal should apply to more useful Excel events, such as BeforeClose etc.
|