Beyond Excel: VBA and Database Manipulation:

August, 2010

1

August 31, 2010  10:16 AM

Strategies for Speeding Spreadsheets

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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...

August 21, 2010  7:47 PM

Controlling the Cursor

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

This post has been superseded. Please see: http://itknowledgeexchange.techtarget.com/beyond-excel/excel-data-entry-protection-solution/


August 9, 2010  8:13 PM

Check Entry – Worksheet_Change – Code

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

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: 

  Bookmark and Share     0 Comments     RSS Feed     Email a friend


August 6, 2010  5:21 PM

Check Entry – Worksheet_Change – Theory

Craig Hatmaker Craig Hatmaker Profile: Craig Hatmaker

There are two times when you want to check entries:
  1. When the user changes something and 
  2. When they want to post entries to the database (aka add, change or delete data). 


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: