+ Reply to Thread
Results 1 to 4 of 4

Date capture in Entry Form to Data Table

  1. #1
    Registered User
    Join Date
    08-18-2007
    Posts
    62

    Date capture in Entry Form to Data Table

    I have a Data Entry Form that captures data entered to a table in a different sheet in the same workbook.
    I want to include the Date the data is entered in a new column in the data table. I want the date been enter with out the user entering or typing the date. After the user makes a data entry with the OK button, I want the code to capture the date and input it with the rest of the info enter in the same row.How can I format a label that will display the date (today’s date) in the Input form and make the "OK" buttom code capture this value (data entry date/today’s date) to the data table? Lets name the sheet were the macro initializing the entry form ” Entry Form Sheet” and where the data table is name “Raw Data Sheet”. I’m following the format use in this example form;

    http://www.exceltip.com/st/Create_Us...Excel/629.html

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello JIBG,

    Using the example you cited, I made changes to include the date. Replace your OK button code with the code here. It will place the date in column "E" of the row the data was entered in. The date format is Sep-01-2007. The code is highlighted in blue. This code could be improved, but I didn't want to confuse you with too many changes that may make it hard to follow.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    08-18-2007
    Posts
    62
    Ross, thanks for you replay. I understand you code to a certain point. But it won’t work the way I wanted
    Let’s make it more simple; If I will have a simple from with just a label how can I programmed it to show today’s date, how can I capture that date and with a OK command button save it to a particular cell in the same workbook but in a different sheet?

    Thanks again for the replay.

    JIBG

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello JIBG,

    Here is a code example of an "OK" button to place today's date in cell A1 of Sheet2. If this isn't what you want, post the code you do have. Don't redirect people to a URL whose code example doesn't match the code the you using.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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