Results 1 to 20 of 20

Help require to record date and time

Threaded View

  1. #11
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Help require to record date and time

    Dear Pan,

    Warm greetings from me!

    First of all I apologize here once again for not understanding your code well before. It’s very close to my requirement now. Only few revisions have to do to make it complete.

    Revisions require:

    Do not hide any sheet, row because I have to enter another data in it. Here I have not entered that data.
    Do not color any cells
    Do not protect any sheet because I have another code in other macro to protect the workbook with password
    No need to enter receipt no. manually. Now here I have inserted the code for automatic receipt no in a8 lc sheet after hitting enter key on a8. Please try to avoide this step to hit enter on a8. It should change automatically after hitting enter key on g7 lc sheet only to speed up the work.
    Cell g4 is filled with another data and here it is blank. So do not use it in this programme.
    No need of pop up message to record the receipt no and date-time. It should be automatic and must without the permission of user.
    There is not a word ‘receipt no’ in my original workbook. Only the receipt no. is in cell a8 lc sheet. I have mentioned here it for you to that there is a receipt no. in cell a8 lc sheet. So avoide referencing cell a7 in the code.
    After entering the register no. in cell g7 lc sheet there is no need to move the cursor on a8 for receipt no. After entering register no. in cell g7 lc sheet and hitting enter key on it (g7 lc sheet) the receipt no. a8 lc sheet should change automatically and cursor should be on g7 only.
    Do not hide variable sheet. I will hide it later.
    Do not limit the register number length because it increasing day by day endlessly.

    Please do the above mentioned revisions in the updated workbook attach here only to avoide any confusion from my end.

    Today I’m very glad to receive a positive solution close to my requirement from you. Hope to receive a final updated workbook today positively.

    I’m feeling very guilty for not understanding the code before and prolonging it long.

    Thank you and have a good evening.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Record date last time button was clicked
    By MaddyG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2013, 11:55 PM
  2. Replies: 1
    Last Post: 01-12-2013, 04:14 PM
  3. Record Date and Time Macro
    By nsorden in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-06-2009, 04:34 PM
  4. Record Time & Date of Event
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2009, 07:27 PM
  5. Macro to record user name and date/time
    By Maddoktor in forum Excel General
    Replies: 0
    Last Post: 12-08-2005, 06:10 PM

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