+ Reply to Thread
Results 1 to 2 of 2

How to make calendar interactive?

  1. #1
    Registered User
    Join Date
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003, 2010

    How to make calendar interactive?


    I downloaded this template and I really like it. What I'd like more is if I could make it interactive.

    I want to be able to click on a cell on the calendar side, and specific notes to pop up on the right, depending on which date I clicked.

    I've set an example on the right as to what I'm looking for. So if I click on march 11th, that information will pop up. I'd like each of the 3 categories to color code depending on how far away from the actual date that it is.

    So in this example, I clicked on March 11th. I want that to always be at the top right there, the date being viewed. The information under it I want shaded in a light green based on the condition that it is within 2 days of the primary date selected. If it is 3-4 days I want it light yellow, and anything 5 days or older I want in a red. This information would have to be variable, because 2 days before the 11th won't be the same as 2 days before the 28th. So on the 28th for example (as the primary day) the 26th and 27th would still be green.

    I'd also need to know where to type in the information for each cell. I'm assuming it'll be on a different sheet somewhere.

    I'd basically go in each morning, grab the dates needed for the categories of NPNR, refunds, and payments and enter them in, and then once I do that it'll update the calendar to show it and hopefully auto shade the dates accordingly depending on where they fall if it were to be clicked on. Is this possible? is there a simpler way to do it?

    Any help at all would be appreciated. Screen shot is included.
    Last edited by Nerfmagnet; 03-26-2015 at 08:12 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16

    Re: How to make calendar interactive?

    Have you tried to google this?

    This looks like it might have some thing for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you


+ 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. Interactive Calendar
    By slate777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2014, 05:00 PM
  2. Interactive Calendar
    By matt.pickard in forum Excel General
    Replies: 0
    Last Post: 11-04-2011, 11:18 AM
  3. How to make interactive calendar with months is sheet doc ?
    By onetwo009 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-18-2010, 07:04 PM
  4. interactive 2 month calendar
    By abelkrista in forum Excel General
    Replies: 2
    Last Post: 01-02-2009, 03:57 PM
  5. Interactive 3 month Calendar
    By TPD in forum Excel General
    Replies: 9
    Last Post: 02-16-2007, 05:20 PM

Tags for this Thread


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