Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trapping Events generated by a Worksheet
Hi Everybody,
I'm looking for a way to accomplish the following: I have an Excel Worksheet that gets populated with data using VBA which gets data from an ADO 2.5 Recordset object in memory on the user's workstation. My goal is to bind the Worksheet to the ADO Recordset i.e. as the user updates, deletes or creates data existing on the worksheet, the ADO Recordset gets updated accordingly. I'm guessing that if I could capture Worksheet events such as an event firing when a row on the Worksheet is deleted, updated, etc... I could use this opportunity to sync the Worksheets data to ADO? I haven't been able to find any events on the Worksheet for Row deletions, updates or insertions, Do they exist? I'm using Excel 97. Thanks for any help! Sam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine 2 worksheet change events | Excel Discussion (Misc queries) | |||
IS THERE A WAY TO CLEAR WORKSHEET EVENTS USING ANOTHER MACRO | Excel Discussion (Misc queries) | |||
Chart Events - Trapping arrow key strokes | Charts and Charting in Excel | |||
Worksheet Events | Excel Discussion (Misc queries) | |||
trapping click events on shapes | Excel Programming |