+ Reply to Thread
Results 1 to 6 of 6

Tell which cell is the first entered value

  1. #1
    Registered User
    Join Date
    10-08-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    62

    Tell which cell is the first entered value

    Hey Group
    is it possibel to make a vba Code to tell me what celle there is entered the first Value in the cell's that are "L5" and "L11" on sheet's "Cup 48 Player's"

    set "1" in celle "L14" if it is "L5" there is first
    or set "2" in celle "L14" if it is "L11" there is first

    i have a sheet with a Cup system

    Cup game.jpg

    hope that was enough Info
    Last edited by Henrik-Chr; 04-26-2019 at 12:16 AM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Tell which cell is the first entered value

    Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
    Paste this code in the module that opens and close it.

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    10-08-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    62

    Re: Tell which cell is the first entered value

    Thanks for the Makro code

    but as always somthing get's Tricky

    If i press "1" or "2" in cell "L11" it's work's Ok and "L14" change to "2"
    But when i Press "1" or "2" in "L5" right after, then it change to "1" in "L14" and that's Wrong

    and when i did it the same otherwise then it give same Error

    Ps No Matter what Solution i use It should be like that, that the cell's Hold first Action

  4. #4
    Registered User
    Join Date
    10-08-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    62

    Re: Tell which cell is the first entered value

    I got it to work

    use Time solution

    if i press "1 or 2" in the first cell a time stam was set
    and when i press "1 or 2"in second cell a time stamp was set

    and then i get form to look like this



    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Tell which cell is the first entered value

    Private Sub Worksheet_Change(ByVal Target As Range)
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    10-08-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    62

    Re: Tell which cell is the first entered value

    thanks for your Reply mehmetcik

    but i already haven Get My problem Solved

+ 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. conditionally format cell B colour based on what number is entered into cell A
    By bell1986uk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2018, 07:22 PM
  2. A manually entered cell to automatically update another manually entered cell
    By Head Scratcher in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 08:23 PM
  3. [SOLVED] Copying today's date into cell when multiple data is entered into adjacent cell
    By SChapman in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-16-2013, 04:12 PM
  4. [SOLVED] Log values entered in a cell single cell via drown menu on sheet1 onto sheet2 in a row
    By jaithorry in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-04-2013, 10:57 AM
  5. Replies: 8
    Last Post: 01-23-2013, 03:36 AM
  6. Replies: 0
    Last Post: 05-25-2009, 06:58 PM
  7. Replies: 2
    Last Post: 04-25-2009, 04:19 AM

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