Popup Reminder Excel 2010 [Closed]

Report
-
Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
-
I am completely new to VBA and do not really know how to manipulate a code.
I was hoping someone would be willing to formulate the codes I need to input into the VBA box.

I have a sheet for appointment dates at a clinic.
They have dates for each patient as below:

Name First Visit Appt 1 2nd Visit Appt 2 3rd Visit Appt 3 .... 10th Visit
x x/x/x x/x/x x/x/x x/x/x x/x/x x/x/x x/x/x
x x/x/x x/x/x x/x/x x/x/x x/x/x x/x/x x/x/x
x x/x/x x/x/x x/x/x x/x/x x/x/x x/x/x x/x/x

I would like a reminder to pop up everytime the appointment date is past 7 days and the patient has not shown up.

example: today's date is 10/9/15

Name First Visit Appt 1 2nd Visit Appt 2 3rd Visit Appt 3 .... 10th Visit
A 6/3/15 7/4/15 7/4/15 8/16/15
B 9/10/15 10/10/15
C 7/10/15 8/11/15 8/11/15 9/15/15 9/15/15 10/1/15

Patient A was last due on Aug 16, 2015 for her 2nd appt (3rd visit), but it has been close to two months since that appointment.
Patient B is OK, so no popup is needed
Patient C is also past 7days from her appointment 3 date.

I would like a popup window to show up for patient A and patient C with a text of "call to remind".

And if possible, disable specific popups (for example, I see reminder for patient A, and I remind the patient already, so there is no need for me to see that patient A needs a reminder any longer)

What would be the best way of doing this?

As the excel gets filled up with more patients, there will likely be more patients who need reminders, therefore more popup windows when the excel is first opened.

Any help would be much appreciated.
Thank you in advance, and please let me know if there is any other info i should provide.

1 reply

Posts
1269
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
January 4, 2021
214
Hello Mdeza81090,

As you are currently receiving help for the same query here:-

https://www.mrexcel.com/board/threads/popup-window-using-vba-excel-2010.982533/

I will close this thread so that our Volunteers do not unnecessarily spend time on a query that is being attended to elsewhere.

Please ensure that you read the rules of the various forums in regard to cross posting. Here at CCM, we have a more lenient attitude towards cross posting but please consider the amount of time that a Volunteer needs to put into a query such as yours and you may then understand the annoyance of finding out that the query is on the verge of being resolved in another forum

We trust that you understand.

Cheerio,
vcoolio.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!