+ Reply to Thread
Results 1 to 9 of 9

time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2011

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    6

    time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2011

    I am sure there are similar post/threads on this but I was not able to find them. Please direct me that way as I do not want to restart a topic that has already been explain and resolved.

    I am attempting to create an excel document that my fire department can use to track and record all our daily activities, emergencies, training etc. I am familiar with the basics of excel but that is about it. I have created the foundation of the document but need help adding in the formulas and "advanced" actions.

    I am using Excel Mac 2011.

    I would like each cell in row a to be updated with the current time when row d is edited and then i would like to be able to double click a cell in row b to add the current time again. I think I attached the excel document. Let me know if I did not.

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Hi and welcome to the forum

    First of all you can't do this with a formula. You'll need a sheet change event macro to do this.

    Would you clarify exactly what you want to see. I understand you are saying that if you enter something in say D10 you want the current time in A10 & B10 - and presumably not C10 since this contains items from a drop down.

    Then in addition of you double click say B10 you want the current time to overwrit what is in B10.

    Is that correct?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    6

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Yes, when I enter something into D column I would like the time stamp to be added only to the column A cell. As that would be the start time or out time and column B is the end times or in times for the vehicles if that makes sense but. I would like the column B cells to get the time stamp after a double click.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Use the following two sheet event macros

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    6
    The problem I am having is I do not know how to navigate excel and where to go too, to enter the code if that makes sense.

    Thank you in advance
    Last edited by AliGW; 02-21-2020 at 08:01 AM. Reason: Please don't quote unnecessarily!

  6. #6
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    6

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Hello. Just checking back in. I am still trying to resolve my issue. As I said I am familiar with excel to the extent of the basics. I do not know where/how to use the event sheet macros. If that makes sense.

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Hi,

    See attched.
    To get to the Visual Basic Environment (VBE) and the macros either use ALT-F11 or right click the tab name and choose View Code


    Assuming you've done the latter with the Daily Log sheet you'll notice that in the top left VBA Project window that Sheet1(Daily Log) has been selected.
    Sheet1 is the VBA sheet code name, (Daily Log) is of course the sheet tab name.
    It's always good practice to use the VBA code name. The tab name is too easily changed by a user an if that happens and you've uses the tab name in your code it will fail.

    Now over on the right at the top you'll see two drop downs, the left hand one has a choice of General or Worksheet.
    With Worksheet selected you'll see in the right hand drop down several 'Events'. Picking one will automatcally create the
    Sub Eventname

    End Sub

    top and bottom of the macro procedure. The event code goes between these two.

    The attached uses the Sheet double click event and the Sheet Change event

    I've added the macros for the Daily Log sheet. You'll need to do the same for the Emergency Log sheet.
    Since the workbook now contains macros it now has a .xlsm rather than the .xlsx file extension name
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    6

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Thank you very much. I was able to get it all sorted.

  9. #9
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    6

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Hello Richard,

    We have been using the document you helped me with for a couple months now. Recenlty some one my coworkers asked if I can make some changes to the document to eliminate the automatic time stamp in the A cell when the D cell is edited. We would like both cells A and B to have the time stamp added after a double click.

    What do I need to remove and add to make these changes to the document?


    Thank you in advance.

    - Justin

+ 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. Putting time stamp into cell with single click
    By timothystow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-11-2018, 01:58 AM
  2. [SOLVED] Insert time stamp on double click
    By SuddenImpact in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2014, 09:55 AM
  3. [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
  4. Double click cell to insert current Time
    By Vetequk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-17-2013, 10:30 AM
  5. Insert automatic date and time stamp in a cell if any cell of the same row is edited
    By kdhanerawala in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-12-2012, 06:18 PM
  6. [SOLVED] Record time stamp once cell is double clicked
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-17-2012, 09:23 AM
  7. Auto fill Date + Double click (time stamp)
    By SVTF in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-05-2012, 03:29 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