+ Reply to Thread
Results 1 to 5 of 5

Employee Holiday Tracker

  1. #1
    Forum Contributor
    Join Date
    12-07-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    117

    Employee Holiday Tracker

    Hi Guys

    How are you All?
    I am having some problem, regarding this tool,
    On the sheet i can only show the days up to 21st for every month.....How can i extend this from up to 31 for all the months
    Please click on OPen form on sheet . on the days available section there are only 21 days, i need this section to show same dates are in calendar..
    Could you please hel me,

    Thanks for your kind help
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Employee Holiday Tracker

    Your problem is in UserForm1.LoadListBox
    Please Login or Register  to view this content.
    When you load array Dates with data from the worksheet, you have hidden the last week in ShowMonth and you are including only visible cells, as seen in the portion of code shown in red above. This code appears to be very deliberate so I'm not sure why you included it if you want to show all days. You could remove that.

    However, that approach will always show 31 checkboxes, even if the month has fewer days, so some checkboxes will be blank. To correct this, calculate the actual range of dates as shown below. This approach eliminates the visibility issue addressed above so you just use the cells you need:
    Please Login or Register  to view this content.
    Now that I have re-read your post, I am unclear on one thing. I was focusing on the form. Do you want these dates to also be visible in the worksheet? The last week of the month is explicitly hidden in ShowMonth. If you don't want it to be hidden, simply comment out the last line of ShowMonth.
    Last edited by 6StringJazzer; 02-05-2010 at 07:31 AM. Reason: Added last paragraph about the hidden columns

  3. #3
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Re: Employee Holiday Tracker

    I have made a couple of changes. I have changed xlCellTypeVisible to xlCellTypeConstants.

    And, now it is working fine.

    Please find attached.

    Regards,
    Karan
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-07-2009
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    117

    Re: Employee Holiday Tracker

    Quote Originally Posted by karan View Post
    I have made a couple of changes. I have changed xlCellTypeVisible to xlCellTypeConstants.

    And, now it is working fine.

    Please find attached.

    Regards,
    Karan


    Hi Karan,
    Thanks for your kind and quick reply,
    its almost done
    but when i select the employee name on the User form1
    I get this message """" Run-time error'1004': No Cells were found

    Could you please have a look again..
    Many thanks
    Kind regards
    Ben

  5. #5
    Forum Contributor
    Join Date
    04-18-2009
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2016
    Posts
    269

    Re: Employee Holiday Tracker

    Hi Benjamin,

    Sorry I had made a mistake. I have corrected it & now it is working fine.

    Please find attached. Let me know if you have any more issues.

    Regards,
    Karan
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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