+ Reply to Thread
Results 1 to 2 of 2

Event-Macro to move the cursor

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Event-Macro to move the cursor

    Hi,

    This time a little weird question.

    Is there a code which will offset the cursor one cell to the left right - exclude col. A at which the error handler will take command - after a single character was typed into a cell ?

    The "catch is that I don't want to press the Enter Key - meaning that in some way the code will be fired right after the single character was typed.

    I prefer a solution without the use of a Form etc.

    This is something similar to what I'm looking for but, unfortunately, in order to be fired it needs hitting the Enter Key.

    Please Login or Register  to view this content.
    I have heard, some "rumors", about Macros to be written into Class Modules but my knowledge in too poor for such codes.

    Thanks, Elm

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Event-Macro to move the cursor

    Excel requires you to press enter to trigger an event macro.

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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