+ Reply to Thread
Results 1 to 2 of 2

Trying to create Sign in Sign out sheet with time stamp

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    Minnesota
    MS-Off Ver
    MS Office 2007
    Posts
    1

    Trying to create Sign in Sign out sheet with time stamp

    I am trying to create a check in and check out sheet for visitors. I've attached what I have so far. Basically the Check in will auto fill Name, Company, Visiting, and Time in. This will also fill Column J if there is a name without a time out. I used an if then to fill that column. In the Check Out macro I've created a ComboBox that uses column J for the Names List. The problem I'm having is in the data validation portion for having to check out. I created a check out button that will populate names based on a list in the J column. But when I hit the OK button I'd like the macro to search for that name and fill in the tMacro Test.xlsmime out cell with a date stamp. I'd like it to allow duplicates as well. For instance if Jane Doe came in at 10 am and signed out at 11 am, then came back at 2pm I'd like it to not change the time stamp for earlier but change the most recent entry. I hope this makes sense to someone. I am really struggling. I was able to create the VB to enter in new data. Let me know if I'm missing information.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Trying to create Sign in Sign out sheet with time stamp

    Try this way.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Employee sign-in userform - Multiple sign ins?
    By Battletoads in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2014, 10:57 AM
  2. Replies: 3
    Last Post: 03-13-2013, 01:20 AM
  3. Looking for an easier way to create a Sign in sheet using Macros
    By Michael Battle in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 05-25-2012, 01:05 PM
  4. Decimal Sign Replaced with ; Sign
    By lopiner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2009, 08:47 AM
  5. XL invoice replace the dollar sign with euro sign
    By Pamela casares in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-16-2005, 04:25 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