+ Reply to Thread
Results 1 to 2 of 2

Click a cell which populates the time of an incident

  1. #1
    Registered User
    Join Date
    03-26-2024
    Location
    Bolton
    MS-Off Ver
    365
    Posts
    1

    Click a cell which populates the time of an incident

    Hello,

    I am trying to create a basic Excel database, which will allow me to click a cell and this populate a time. I am tracking incidents in a football match, so want to click the box, and this will populate a time from 0 minutes to 90 minutes (allowing for this to run over when needed allowing for additional time lost). I would click say Cell A3 at 4 minutes in the game, and this will then populate 4 in A3... etc etc.

    The spreadsheet works on a number of drop down boxes etc, for Columns B to K. it would only be Column A that would auto populate on the click;.

    Any help greatly appreacaited.

    thank you
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,946

    Re: Click a cell which populates the time of an incident

    The attached has code - so you need to enable macros to get it to work.

    The code will enter start time in cells A2 and B2 - click A2 when the center referee starts the match, and B2 when the second half starts.

    Then click any cell in column A and the minute of the game will be entered, relative to the start time of the appropriate half.

    To update any cell in A (or A2 and B2), simply re-click it. Or you can simply delete the time if you clicked the cell in error.

    Also, the code will not enter 0 minutes - I followed the convention that the start of the match is the first minute, or 1m.
    Attached Files Attached Files
    Last edited by Bernie Deitrick; 03-26-2024 at 03:38 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Hyperllink that populates the date and time on the target sheet in the correct cell
    By TheNewBoy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2023, 06:34 AM
  2. time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2011
    By JNicholas in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 06-01-2020, 01:13 PM
  3. SLA TIME by Incident
    By itzguri in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-23-2019, 12:04 PM
  4. Replies: 3
    Last Post: 02-26-2014, 09:26 PM
  5. [SOLVED] Double click to fill cell with date&time and a cell before with applicationuser name
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2014, 01:14 PM
  6. Text Box that opens when cell is click and populates based on a lookup
    By Whirlpool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2013, 07:55 AM
  7. Time Stamp when relevant value populates neighboring cell
    By Robertluckett in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-22-2013, 09:06 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