Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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 -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "myfather" wrote in message ... 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. |
#3
![]() |
|||
|
|||
![]()
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. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "myfather" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Same event, multiple sheets? | Excel Discussion (Misc queries) | |||
Excel Automation SelectionChange event | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Change of Row event | Excel Discussion (Misc queries) | |||
Event 1001 & 1004 | Excel Discussion (Misc queries) |