+ Reply to Thread
Results 1 to 2 of 2

TimeStamp on a UserForm

  1. #1
    Registered User
    Join Date
    09-17-2018
    Location
    Loudonville, Ohio
    MS-Off Ver
    Office Professional Plus 2016
    Posts
    1

    TimeStamp on a UserForm

    I have a UserForm that tracks entries by Roving Quality on an hourly basis. The data is generated on laptops that are used by the inspectors on the production lines, and the data is then displayed on a central data base. I need a way to Timestamp the data on the central computer when the inspector enters the data using a cmdAdd button.


    I've tried several different Private Sub UserForm programs to add this data, so far with negative results. Incidentally the data come to a data row, and I would like to have this timestamp entered on the last cell of that row.


    Thanks in advance,
    BillyBob2
    Last edited by BillyBob2; 09-17-2018 at 11:14 AM. Reason: mis-spelling

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: TimeStamp on a UserForm

    Welcome to the Forum BillyBob2!

    The answer to this is very specific to your file. I would want to see the code for cmdAdd_Click and also the layout of the data on the worksheet. In general you are simply going to add an extra column and assign Date to that column in the new row. But I can't give you actual code without seeing your file.

    Please attach your file, and remove any private data. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Userform - integrating code from old form into new template, timestamp, ID No etc
    By excelconditional in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-29-2017, 04:37 PM
  2. Replies: 2
    Last Post: 11-09-2016, 02:23 PM
  3. [SOLVED] VBA - Convert Date/Timestamp into American Date and Military Timestamp
    By ryanmorris in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-01-2015, 03:43 PM
  4. Replies: 18
    Last Post: 02-24-2014, 06:13 PM
  5. [SOLVED] Userform for combolist/timestamp and commments code
    By nmckever in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2012, 02:33 AM
  6. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM
  7. Timestamp
    By ctasich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2010, 11:33 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