I want to add a sound event when the cursor bumps left margin

M

myfather

I want to know (via an event sound) that my cursor movement has bumped the
left edge of the spreadsheet. I am entering thousand of rows of data, and it
would help if there was a event sound when I returned the cursor to the left
edge. I have this feature in 123, and find it helpfull.
 
E

Earl Kiosterud

Put this in the sheet module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static ColOld As Integer
If Target.Column = 1 And ColOld > 1 Then Beep
ColOld = Target.Column
End Sub
 
E

Earl Kiosterud

Here are a couple of things that, though not answering your question, might
interest you.

You might want to use Data - Form.

Another technique that might apply is to use the Tab key instead of the
Enter key as you move across the row. Then at the last cell, press Enter.
It will take you to the next row, in the column where you started.
 
Top