Results 1 to 20 of 20

Help require to record date and time

Threaded View

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

    Help require to record date and time

    Dear friends,
    Please suggest me a correction in this macro to achieve require output.

    Sheets("LC").Range("G7").Select
        ActiveCell.FormulaR1C1 = "1"  ‘Here I want to enter the any register number of student and hid enter key
                Sheets("LC").Range("A8").Select  ‘Here I want to hid enter key and then a formula should be enter on ‘Register’ sheet in cell AA6 as follows
    Selection.FormulaR1C1 = _
            "=LC!R[1]C[-26]&CHAR(10)&TEXT(LC!R[21]C[-25], ""dd/mm/yyyy hh:mm AM/PM"")"
                        Formula = Value ‘It’s very important because the date and time is continuously changing in cell b28 on LC sheet
    End Sub
    Requirements:
    I want to know how many times and when the student has taken LC. The date and time should be on register sheet from column ‘AA:AE’ respectively for each student.
    The register number is a unique id for each student.
    I want to hid enter key on cell ‘g7 and after a8’ on LC sheet. It is very important to hid enter key on a8 because after hiding the enter key the receipt number change automatically. Though the register number of a student is same but the receipt number for each receipt is different for each time.
    I want the date and time of lc given infront of each student respectively.

    Any help will be appreciated to achieve this target.

    Thanking you in anticipation.
    Attached Files Attached Files
    Sincerely,

    mso3

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