Results 1 to 3 of 3

Thread: Needing help with visitor log

  1. #1
    Neophyte Lks's Avatar
    Join Date
    Feb 2015
    Location
    Mokelumne Hill, CA
    Posts
    2
    Articles
    0

    Needing help with visitor log



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm hoping I chose the correct forum. A friend is trying to recreate a Visitor's Log they saw somewhere. It has a macro button than when pushed goes to the next empty row and enters the current date in column A and current time in column B. I've seen many variations on several forums but have yet to locate this particular scenario. Thank you.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    see attached which contains a button on a sheet and this code:
    Code:
    Private Sub CommandButton21_Click()
    With Cells(Rows.Count, 1).End(xlUp).Offset(1)
      .Value = Date
      .Offset(, 1) = Time
    End With
    End Sub
    Attached Files Attached Files

  3. #3
    Neophyte Lks's Avatar
    Join Date
    Feb 2015
    Location
    Mokelumne Hill, CA
    Posts
    2
    Articles
    0
    Mission accomplished. Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •