Results 1 to 4 of 4

Calendar Made Using VBA Does Not Show Events for Last Week of the Month

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2022
    Location
    Toronto,Ontario
    MS-Off Ver
    2019
    Posts
    1

    Calendar Made Using VBA Does Not Show Events for Last Week of the Month

    So I have created a calendar that can change month and year. It can also input events with the date attached to it. I will be referencing October 2022 when facing this problem. Whenever I have a month that has the final week in the 6th week (such as October 2022 or July 2023), if I input an event for the 31st, it will not show up in the calendar (only on the date sidebar). If I input something for the 30th, not only will it not show up on the 30th, it will input the event on every blank space that isn't in that month. For example in October 2022, the month starts on a Saturday and the Sunday-Friday before that should not have any dates with them as they are in September. It will paste the event continually from that Sunday to Friday.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calendar with auto-populating events (multiple events in a single date)
    By zankzank in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-20-2021, 09:41 AM
  2. Events Month per Sheet Calendar help
    By kifirth in forum Excel General
    Replies: 7
    Last Post: 02-17-2021, 10:05 AM
  3. Multiple events same date calendar will only show one event per day not all
    By KtB73 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2020, 12:34 AM
  4. [SOLVED] Splitting days in a week over a calendar month
    By Gti182 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2019, 04:54 AM
  5. Calendar VBA auto filling week and month based on calendar entry.
    By perrymagic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2011, 02:00 PM
  6. Calendar Week of Month
    By longfisher in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2007, 07:09 AM
  7. Show week number in current month
    By DKerr in forum Excel General
    Replies: 4
    Last Post: 02-23-2006, 05: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