NeilK
Reputation: 21
In Excel vb.net sheetchange event, how can i differentiate between a cell edit and a cell deletion
In an Excel vb.net vsto add-in, editing the contents of a cell, say A1, triggers the sheetchange event. Deletion of cell A1 (not deletion of its contents but deletion of the cell) also triggers the sheetchange. In both cases, Target is A1. How can I differentiate between these two events?
Upvotes: 1
Views: 32
Answers (0)
Related Questions
- How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
- Is it possible to force Excel recognize UTF-8 CSV files automatically?
- How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
- .NET Global exception handler in console application
- Add sub-menu to cell context menu in Excel in vb.net
- Delete Sheets and avoid Excel asking the user to confirm, using custom messages instead
- VB.Net: Inserting Data Validation In Excel Cell
- How can I detect cell text changing in VSTO add-in with C#?
- In VSTO Addin for Excel how to handle a button click event from active worksheet?
- How can I determine new & previous cell value on SheetChange event in Excel?