+ Reply to Thread
Results 1 to 7 of 7

Repeat Events Calendar

  1. #1
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Repeat Events Calendar

    Lost at why this will not work, This is the the work of another member on the forum.Andy is a good programmer but
    not on much. I made some changes to Form and its not working right. Maybe a expert can see what I did wrong,the repeat event is not repeating events
    for future years. This has some great code work by Andy,when using as add-in its very helpful. Deeds some clean up but that can wait for now.

    Z
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Repeat Events Calendar

    This is driving me crazy, missing something.Think the problem is in userform Sub LoadDataFromWksht(ByVal SelectedDate As String, X As Integer)

  3. #3
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Repeat Events Calendar

    Lot of people looking,any idea's yet? The code work is pretty complex so way over
    my head.Hoping a expert can make it work.If this was a add-in could it be called with commandbutton
    in another book?.I can right click for menu but would like to open with userform button.

  4. #4
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Repeat Events Calendar

    Got it working, here is a updated version. One problem I have is getting calendar to
    go past 2029?
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Repeat Events Calendar

    Getting this error if I try and input data into years above 2029
    wb1.Sheets(ShtName).Range("A" & Row).Value = TheDate 'Unconditionally puts the date into column a
    Can't make the calendar work above year 2029 at all,?

  6. #6
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Repeat Events Calendar

    No matter how much I go over code, just don't understand what causes the problem with years after 2029.Everything works until 2029, I can put a repeat event in until 2060 and it install the data right.Click on
    calendar past 2029 and get error. I'm looking on some advice on a fix,
    Thanks Z

  7. #7
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Repeat Events Calendar

    With 200 views seems like someone would have answer.I admit this is over my head that is why I need expert help.There are a lot of Great programmers on this site and
    hoping one will see the problem.The Calendar works in all months in 2029 until you get to December.

    Happy Holidays Z

+ 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. Formula for Calendar with reoccuring events
    By jnm014 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-16-2015, 10:59 AM
  2. Add recurring events to an excel calendar
    By Kaitken123 in forum Excel General
    Replies: 0
    Last Post: 09-28-2014, 08:55 PM
  3. Populating a calendar with list of events
    By bwells3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2011, 05:31 PM
  4. Re-arranging Dated Events for Calendar Upload
    By Banjo_Man in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2009, 01:38 PM
  5. Macro to forward IMPORTANT calendar events.
    By eckert1961 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 06-05-2009, 12:57 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