+ Reply to Thread
Results 1 to 6 of 6

Timestamps to existing vba code

  1. #1
    Registered User
    Join Date
    03-29-2022
    Location
    Croatia, Zagreb
    MS-Off Ver
    Office 365
    Posts
    6

    Timestamps to existing vba code

    Hello, can someone help me with timestamps? I need to add timestamps (date and time) to existing code - column D and F would have timestamps , column C and E would be for traders to enter the time.
    Thank you for any help/advice
    code attached
    Attached Files Attached Files
    Last edited by skask001; 04-01-2022 at 03:17 PM.

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: Timestamps to existing vba code

    Add these three lines to the macro event WorkSheet_Change and have a try:
    Please Login or Register  to view this content.
    then maybe you need to lock the timestamps too.
    Last edited by rollis13; 04-01-2022 at 05:26 PM.

  3. #3
    Registered User
    Join Date
    03-29-2022
    Location
    Croatia, Zagreb
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Timestamps to existing vba code

    Hey, THANK YOU, IT WORKS LIKE A CHARM, RESPECT!!!!
    And if i may just one more question pls ; if i want same thing that you wrote but for other columns (9,11,15,17 etc.)?

  4. #4
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: Timestamps to existing vba code

    In this case I would use this:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-29-2022
    Location
    Croatia, Zagreb
    MS-Off Ver
    Office 365
    Posts
    6

    Re: Timestamps to existing vba code

    Thanks for fast response and for your time!!! everything works perfect; Thank you once again!

  6. #6
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    917

    Re: Timestamps to existing vba code

    Thanks for the positive feedback , glad having been of some help.

+ 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. [SOLVED] Timestamps for Multiple Columns. Need to Modify the Code
    By bssol in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-11-2022, 03:06 AM
  2. I want a code that can count the no. of rows covered in an hour using the timestamps
    By John521520 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-06-2022, 09:16 PM
  3. [SOLVED] Adapting Existing Code to Offer Option to Save to Existing Folder
    By AliGW in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2019, 07:37 AM
  4. update existing code to copy and KEEP existing data
    By scott micklo in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-26-2016, 05:41 PM
  5. [SOLVED] Correct way to apply an existing VBA code to an existing sheet
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 05:42 PM
  6. Replies: 1
    Last Post: 08-15-2009, 05:52 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