+ Reply to Thread
Results 1 to 2 of 2

Status message after hitting enter

  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    Cerritos, CA
    MS-Off Ver
    Excel 2010
    Posts
    31

    Status message after hitting enter

    Greetings Forum...

    I've looked for answers on this before posting, but if I missed a related post, my apologies. I've been looking for a solution to display a "Please wait" message to fill an adjacent cell or to show on a user form after hitting the enter key, as the calcuation that takes place takes at least 10 seconds. Everything I've found for a solution is based on when a macro is running, however the calculation is not a macro, it's simply a big calculation that takes place after a value is entered into a specific cell.

    Any help or ideas are much appreciated.

    Stumped in Cerritos.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: Status message after hitting enter

    hi, eventually you can try to combine worksheet_change event to display the message in the status bar when this specific cell has changed and worksheet_calculate event after the sheet is recalculated to clear status bar.
    If you are pleased with a member's answer then use the Star icon to rate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 12-06-2010, 04:39 PM
  2. Hitting Enter after Tab
    By tmix in forum Excel General
    Replies: 3
    Last Post: 09-17-2009, 04:19 PM
  3. Hitting Enter
    By Laythe in forum Excel General
    Replies: 3
    Last Post: 12-16-2008, 11:41 AM
  4. Hitting enter
    By smilegirl in forum Excel General
    Replies: 1
    Last Post: 10-17-2008, 05:08 PM
  5. Replies: 2
    Last Post: 10-20-2005, 05:05 PM

Tags for this Thread

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