hi, I have a worksheet where the displayed data is extracted from an Access db. I use VBA and DAO (I think) for this. I would like the user to be able to make changes that will be updated in the database. I'm really not sure about a good way to approach this. One method I saw for keeping track of changes made was to attach some code to the worksheet_change event. This also involved testing a global variable that kept track of whether other code that was loading data was in the middle of running. See what I mean? Does that sound like a good way to do it? I could simply require the user to click on an update button and at the very worst the code could update the db with every line from the worksheet whether changed or not. Does anybody who has done something like this before have any advice?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
updating a db on worksheet_change event
- Thread starter dhoffman
- Start date
