Needing help with visitor log

Lks · Feb 1, 2015

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.

p45cal · Feb 1, 2015

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

Lks · Feb 4, 2015

Mission accomplished. Thank you.

Needing help with visitor log

Lks

New member

p45cal

Super Moderator

Attachments

Lks

New member