| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_SheetChange triggered to many times
Hi there!
When user enters some text in a cell, I use macros to validate. If there are some incorrect data I want to correct this programmatically. So I use the SheetChange event. The problem is that when I correct what the user entered, the event is fired once again, and then again and again and again... I think you understand the problem... How can I work around this problem, is it for example possible to temporarily disable the event? Best Regards L-E |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook_SheetChange triggered to many times
Before you write to the cell, tell excel to stop looking for changes.
application.enableevents = false 'your code here application.enableevents = true Devvy D wrote: Hi there! When user enters some text in a cell, I use macros to validate. If there are some incorrect data I want to correct this programmatically. So I use the SheetChange event. The problem is that when I correct what the user entered, the event is fired once again, and then again and again and again... I think you understand the problem... How can I work around this problem, is it for example possible to temporarily disable the event? Best Regards L-E -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Workbook_SheetChange triggered to many times
Thanks a lot, never used that before, but it works like a charm!
Dave Peterson wrote: Before you write to the cell, tell excel to stop looking for changes. application.enableevents = false 'your code here application.enableevents = true Devvy D wrote: Hi there! When user enters some text in a cell, I use macros to validate. If there are some incorrect data I want to correct this programmatically. So I use the SheetChange event. The problem is that when I correct what the user entered, the event is fired once again, and then again and again and again... I think you understand the problem... How can I work around this problem, is it for example possible to temporarily disable the event? Best Regards L-E |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet_Change and Workbook_SheetChange not firing | Excel Programming | |||
| Workbook_sheetChange event | Excel Programming | |||
| workbook_sheetchange | Excel Programming | |||
| Problem with the Workbook_SheetChange event??? | Excel Programming | |||
| Workbook_SheetChange will not fire | Excel Programming | |||
Linear Mode
