By guest contributor: Yoav Ezer
NOTE: This post provides an example spreadsheet: accelerating-excel.xlsm. Due to concern for your system's security, macro enabled...
Updating databases demands discipline. Excel is about freedom. It's what your users love about it. Even so, updating databases demands discipline and striking the right balance between freedom and discipline is key to making Excel a great tool for users and DBAs. We've just invested most...
Last post we discussed the theory behind the WorkSheet_Change event code below. This code must be in the WorkSheet class as it only responds to events for the worksheet that contains it. Here is the code:0 Comments RSS Feed Email a friend
When the user changes something and
When they want to post entries to the database (aka add, change or delete data).