Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: automated cursor movement

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    want cursor to go automaticly to top of the next column. 6 colums 10 rows. a10 or b10 data entered then it will go to c1...

  2. #2
    Guest

    Default

    You'll need to write some VBA code for this.
    Select Tools - Macro - Visual Basic Editor
    Make sure the Project Explorer is visible on the left (otherwise View - Project Explorer)
    In the Project Explorer, Open folder Microsoft Excel Objects under the workbook and double click on the sheet you want to behave as you described. A VBA window opens on the right side.
    In this window, select "Worksheet" in the left pulldown (on top, saying (General)) and select Change in the right pulldown.
    A "skeleton subroutine" appears in the window that looks like this:
    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    End Sub

    Now add the following code line between the two lines of code just mentioned:
    If Target.Row = 10 Then Target.Offset(-9, 1).Select

    Now go back to you excel sheet and try it out.

    Marc

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •