+ Reply to Thread
Results 1 to 2 of 2

onkey method

  1. #1
    Registered User
    Join Date
    03-25-2004
    Posts
    57

    onkey method

    Hi,
    Is it possible to make the onkey method work when other data has been entered in a cell?
    For example, in the onkey method I have set, when "+" is keyed, the cursor will move to a specified cell.

    If I key in, say, "1" and then "+", can I make the onkey method work? or I am stuck with the problem of macros not working when in Edit mode?

    Thanks for any help

    free

  2. #2
    Bob Phillips
    Guest

    Re: onkey method

    Macros don't fire when in edit mode, and will not until AFTER edit is
    completed.

    --
    HTH

    Bob Phillips

    "freekrill" <freekrill.1ws22e_1129100756.3882@excelforum-nospam.com> wrote
    in message news:freekrill.1ws22e_1129100756.3882@excelforum-nospam.com...
    >
    > Hi,
    > Is it possible to make the onkey method work when other data has been
    > entered in a cell?
    > For example, in the onkey method I have set, when "+" is keyed, the
    > cursor will move to a specified cell.
    >
    > If I key in, say, "1" and then "+", can I make the onkey method work?
    > or I am stuck with the problem of macros not working when in Edit
    > mode?
    >
    > Thanks for any help
    >
    > free
    >
    >
    > --
    > freekrill
    > ------------------------------------------------------------------------
    > freekrill's Profile:

    http://www.excelforum.com/member.php...fo&userid=7561
    > View this thread: http://www.excelforum.com/showthread...hreadid=475302
    >




+ 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