excel

Strategies for Speeding Spreadsheets

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

Controlling the Cursor

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

Check Entry – Worksheet_Change – Code

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

August 6, 2010  5:21 PM

Check Entry – Worksheet_Change – Theory

Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

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

      0 Comments     RSS Feed     Email a friend

July 22, 2010  6:59 PM

Check Entry – Post_Click Event

Posted by: Craig Hatmaker
database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

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

         0 Comments     RSS Feed     Email a friend

   ---

   July 20, 2010  8:48 PM
   
   

   Check Entry – Initializing Globals

   
   
   Posted by: Craig Hatmaker
   database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

   [caption id="attachment_709" align="alignright" width="103" caption="You are here (Click to enlarge)"]

         0 Comments     RSS Feed     Email a friend

   ---

   July 13, 2010  10:12 AM
   
   

   Check Entry – The Controlling Routine

   
   
   Posted by: Craig Hatmaker
   database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

   [caption id="attachment_710" align="alignright" width="103" caption="You are here (Click to enlarge)"]

         0 Comments     RSS Feed     Email a friend

   ---

   July 6, 2010  9:44 PM
   
   

   Check Entry – Dealing with Field Level Exceptions

   
   
   Posted by: Craig Hatmaker
   database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

   We're just about finished dealing with the Check_For_Normal_Entry_Errors.  It uses one routine we haven't discussed, Cust_Edit.  Cust_Edit handles any field level validation that Check_For_Normal_Entry_Errors can't. ...

         0 Comments     RSS Feed     Email a friend

   ---

   July 1, 2010  9:32 PM
   
   

   Check Entry – Marking Cells as having passed or failed

   
   
   Posted by: Craig Hatmaker
   database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

   The last post talked about a generic validation routine.  That routine requires some functions that I will provide code for in this post. These functions convey to users and other routines which cells: can change; have changed, have passed validation; or have failed.  Users need this...

         0 Comments     RSS Feed     Email a friend

   ---

   June 30, 2010  9:30 PM
   
   

   Check Entry – Common Validations

   
   
   Posted by: Craig Hatmaker
   database, development, excel, Microsoft Excel, ms query, odbc, sql, tutorial, vba

   Today's post is about a routine I call Check_For_Normal_Entry_Errors.  In my opinion, the toughest part of coding is checking for entry errors because just knowing what good values look like isn't good enough.  You also need to anticipate anything a user might do even though it...

         0 Comments     RSS Feed     Email a friend