+ Reply to Thread
Results 1 to 8 of 8

Problem with Time Stamp in comments...

  1. #1
    Registered User
    Join Date
    11-04-2008
    Location
    London
    Posts
    20

    Problem with Time Stamp in comments...

    I have been able to use a time stamp code to put a date and time in a cell... I then worked out how to use this to list dates and times in the same cell (instead of replacing the cells contents)... using this code:

    Please Login or Register  to view this content.
    Now i can use the time stamp to input into a comments box using this code:

    Please Login or Register  to view this content.
    But i cannot get it to list the dates in the comments box each time i stamp rather than replace the existing comments... Can anyone help?
    Last edited by VBA Noob; 11-10-2008 at 09:10 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You now have 3 threads with this question! Have you read the Forum Rules, especially about duplicate posts?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,177
    I found some code and modified it for your code, is this what you want?
    Please Login or Register  to view this content.
    Regards

    Rick
    Win10, Office 365

  4. #4
    Registered User
    Join Date
    11-04-2008
    Location
    London
    Posts
    20
    Ok... almost there. It does add the text to the comment box without deleting it but i dont want it to add any text to the cell itself...

  5. #5
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,177
    Remove this line:
    Please Login or Register  to view this content.
    I thought you were appending the contents of the cell and comment.

  6. #6
    Registered User
    Join Date
    11-04-2008
    Location
    London
    Posts
    20
    Yep i found that... the trouble is... when i run it the second time... all it is doing is duplicating whats in the comment... not adding a new date and time. For example if there is 07/11/2008 12.45 in the comment box... if i click it again it just duplicates it rather than adding the new date and time. Is this a fault with the code?

  7. #7
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Ladson SC
    MS-Off Ver
    Office365
    Posts
    1,177
    Oops, I was testing the appending, not the actual content.
    Try this:
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    11-04-2008
    Location
    London
    Posts
    20
    Thats brilliant The only issue was the it put in the text Date + Time, Followed by the date and time... but i was able to resolve that. Cheeeeeeers :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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