September, 2010

Controlling the Cursor: Find_Unlocked_Cell

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)

Controlling the Cursor: Position_Curosr_In_Data

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

Back to Controlling the Cursor

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