+ Reply to Thread
Results 1 to 4 of 4

Make text cursor appear at the start of a cell?

Hybrid View

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    6

    Make text cursor appear at the start of a cell?

    Hi.

    Is there a way to make the text cursor appear at the start, as opposed to at the end, of a cell when pressing F2 to edit it?

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Make text cursor appear at the start of a cell?

    Assign this short macro to a shortcut key:

    Sub dural()
    Dim L As Long
    With ActiveCell
        L = Len(.Value)
        Application.SendKeys "{F2}"
        For LL = 1 To L
            Application.SendKeys "{LEFT}"
        Next LL
        DoEvents
    End With
    End Sub
    Gary's Student

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Make text cursor appear at the start of a cell?

    Why not use the Home key if you are to use sendkeys?

        Application.SendKeys "{F2}{HOME}"
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Make text cursor appear at the start of a cell?

    Hi Andy:

    You are correct!
    The idea did not occur to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1