T
tkt_tang
Re : Excel Consequential Events Worksheet_SelectionChange and
Worksheet_Change
1. Open an Excel worksheet and enter the event-handling code of
Worksheet_SelectionChange and Worksheet_Change in the worksheet module.
2. The given events are consequential ; Worksheet_SelectionChange to be
followed suit by Worksheet_Change.
3. Given that the worksheet is activated by the event of
Worksheet_SelectionChange, the state of the worksheet is assessed and
the status recorded thereof.
4. Should there be followed suit by another event of Worksheet_Change,
the Status Record of the (prior event) Worksheet_SelectionChange will
be taken into consideration in the new state of the worksheet.
5. Quite simply, the Status Record is the value of a variable to be
passed between the events of Worksheet_SelectionChange and
Worksheet_Change.
6. But, how could a means be devised to pass along the Status Record ?
7. Please share your comments. Regards.
Worksheet_Change
1. Open an Excel worksheet and enter the event-handling code of
Worksheet_SelectionChange and Worksheet_Change in the worksheet module.
2. The given events are consequential ; Worksheet_SelectionChange to be
followed suit by Worksheet_Change.
3. Given that the worksheet is activated by the event of
Worksheet_SelectionChange, the state of the worksheet is assessed and
the status recorded thereof.
4. Should there be followed suit by another event of Worksheet_Change,
the Status Record of the (prior event) Worksheet_SelectionChange will
be taken into consideration in the new state of the worksheet.
5. Quite simply, the Status Record is the value of a variable to be
passed between the events of Worksheet_SelectionChange and
Worksheet_Change.
6. But, how could a means be devised to pass along the Status Record ?
7. Please share your comments. Regards.