+ Reply to Thread
Results 1 to 3 of 3

Employee Schedule

  1. #1
    Registered User
    Join Date
    12-05-2014
    Location
    BC Canada
    MS-Off Ver
    2013
    Posts
    2

    Employee Schedule

    I have a work schedule that I have created and I would like to place some code in there that verifies the entries are a proper time format and not text.

    I have the basic part of the code done but I'm having some difficulty with it searching through the various cells. Unfortunately the cells are just one big list or it would be easy enough for my code to work. I started to create multiple ranges and I was going to create some for statements to cycle through but I figure there must be a simpler way. You will find my attached worksheet.

    Any help would be appreciated. I've attached what I have so far.

    EMAC 2014 Schedule vba times2.xlsm
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    09-22-2012
    Location
    Berkeley, CA
    MS-Off Ver
    Excel 2010
    Posts
    112

    Re: Employee Schedule

    I'm not 100% sure what your objective is, but have you considered using the data validation feature? I think it might accomplish what you're wanting to do. You can set the data validation for the desired cells to show a time in between whatever values you need.
    ------------------------
    W2

  3. #3
    Registered User
    Join Date
    12-05-2014
    Location
    BC Canada
    MS-Off Ver
    2013
    Posts
    2

    Re: Employee Schedule

    Okay I was able to use data validation to get my dates to work as I need them.

    I now need to get this code working. I have it working if i put it in a command button. But I would like it make the calculations needed when the cell data is changed.

    Command Button Code
    Please Login or Register  to view this content.

    By Change Code (Not working)

    Please Login or Register  to view this content.

+ 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. Replies: 8
    Last Post: 07-15-2013, 07:13 PM
  2. Replies: 2
    Last Post: 09-19-2012, 10:52 AM
  3. employee schedule
    By jarrodguyer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-03-2010, 10:45 PM
  4. employee schedule
    By wingsofeagle in forum Excel General
    Replies: 1
    Last Post: 07-03-2008, 09:16 AM
  5. Employee Schedule
    By henrikjt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2006, 10:16 AM

Tags for this Thread

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