Help producing a calendar which displays information in pop up form for each day?

BSWJON

Board Regular
Joined
Mar 24, 2014
Messages
101
Office Version
  1. 365
Platform
  1. Windows
Hi Folks,

I've been asked to create a diary type document for recording when certain documents are due for review. What I would like to do is have a caldendar type format, which changes the month being displayed when the user changes themonth from a drop down- this much is easy enough, I've downloaded a template for it in fact.

The next part though is the tricky bit- I would like a pop-up form to be produced which contains information pertinent to the docuent due for review, and for this form to be saved to the relevant day. So what needs to happen is that the pop up form is saved to the day on the calendar, this way it can be referenced in the future. The form doesn't need to enter data into another table once completed, it just needs to retain the information entered into it.

Is this possible?

So process again is, for clarity:
  1. select day from scrollable calendar
  2. press a button which opens a blank form uniquely attributed to that day
  3. enter data into form
  4. save form
  5. form remains when scrolling onto other months
  6. form can be edited whenever required
So far I have found a calendar template which provides the basis for a scrollable calendar, and have just about worked how to create a user form- however everything else, I am yet to work out.

Any help, as ever, is greatly appreciated.

Thanks :)
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

BSWJON

Board Regular
Joined
Mar 24, 2014
Messages
101
Office Version
  1. 365
Platform
  1. Windows
Edit: The calendar template does not store data once you navigate to/view other months. So this would need resolving as a starting point to begin with!
 

Forum statistics

Threads
1,143,909
Messages
5,721,455
Members
422,363
Latest member
Bogus_Potatoes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top