+ Reply to Thread
Results 1 to 2 of 2

Ignore entered cell if not tabbed off it

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    59

    Ignore entered cell if not tabbed off it

    I have a scoreboard where I have a button to correct the last score entered. Say for example I enter:

    A1 = 100
    B1 = 100

    Then I click the correct score button, it deletes B1, changes it to blank, and leaves the cursor there to re-enter correctly.

    However, if I click the correct score button, before tabbing off B1 (i.e. I enter 100 in B1, don't tab or press enter, and click the correct score button), then A1 is cleared, and B1 remains.

    Is there any way that in this instance, B1 goes blank along with A1, or is the order of events and position of cursor going to make this too complicated?

    Happy to elaborate if the above doesn't make sense and appreciate any help

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: Ignore entered cell if not tabbed off it

    If you don't press enter or tab out of the range, then your are still in edit mode and nothing will work until you are out of edit mode.

+ 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. Popup date picker when cell is clicked but NOT when tabbed into cell?
    By xdrenched in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2016, 04:21 PM
  2. Condition Formatting: when one cell had data entered, ignore another
    By FarazM in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2014, 06:16 PM
  3. Need to ignore text entered in range for formula
    By PeteABC123 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2014, 04:46 PM
  4. [SOLVED] Can lookup formula ignore blank cells until the lookup value has been entered?
    By Ju1cy in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-13-2014, 01:32 PM
  5. Replies: 3
    Last Post: 06-18-2013, 03:40 AM
  6. Replies: 9
    Last Post: 10-25-2011, 10:33 AM
  7. [SOLVED] How can you enable a combobox to be "tabbed" or entered out of?
    By Erika in forum Excel General
    Replies: 1
    Last Post: 04-22-2005, 12:21 PM

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