ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running Event Procedure When Cell Updated on Excel Worksheet (https://www.excelbanter.com/excel-programming/307456-re-running-event-procedure-when-cell-updated-excel-worksheet.html)

Tom Ogilvy

Running Event Procedure When Cell Updated on Excel Worksheet
 
Right click on the sheet tab

Select view code

in the left dropdown select worksheet, in the right, Change (not
selectionchange)

Use this event which is fired when a cell is updated manually or by code.

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on Excel events.

--
Regards,
Tom Ogilvy

"Eddie U" <Eddie wrote in message
...
I wish to trigger a event proceure on update of a cell or range of cells

in a
excel (2000) worksheet.
This would mimic the after update event on a Access form control .
Any ideas please.





All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com