Beyond Excel: VBA and Database Manipulation:

September, 2010

1

September 23, 2010  7:45 PM

Controlling the Cursor: Find_Unlocked_Cell



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

Today's little routine was repeated all throughout Position_Cursor_In_Data (See previous post).  It's a simple little routine with not much to talk about except one little trick:

v = Intersect(ActiveWindow.VisibleRange, Selection)
If you...

September 14, 2010  8:02 PM

Controlling the Cursor: Position_Curosr_In_Data



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

The last few posts covered Worksheet_Change and Worksheet_SelectionChange events.  Both rely on a function called Position_Cursor_In_DataPosition_Cursor_In_Data's Job is...


September 8, 2010  5:49 PM

Back to Controlling the Cursor



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

This post returns to controlling the cursor in update spreadsheets. As the user positions the cursor on the spreadsheet, we want to have it jump over 'locked' cells to the next 'unlocked' cell.  The words 'locked' and 'unlocked' are quoted because we aren't exactly using Excel's notion of...


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: