Popup window using VBA Excel 2010

[mdeza81090]

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: if today's date were 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 7 days from her latest appointment 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 once, so there is no need for me to see that patient A needs a reminder multiple times)

What would be the best way of doing this?

I am aware that 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.

 

[mdeza81090]

the example i gave did not come out veey well, so here is another example.

Assuming that the date is Dec 30 2016, i need popups for every patient whose appt is 7 days past the appointment date.

First Visit

2nd Visit

3rd visit

4th visit

5th visit

6th visit

7th visit

Patient

First Visit Date

Appt Date

Date of visit

Appt Date

Date of visit

Appt Date

Date of visit

Appt Date

Date of visit

Appt Date

Date of visit

Appt Date

Date of visit

A

2016/5/1

2016/6/1

2016/6/1

2016/7/11

2016/7/10

2016/9/10

2016/9/10

B

2016/7/15

2016/8/20

2016/8/10

2016/10/11

2016/10/9

2016/11/15

2016/11/17

C

2016/6/23

2016/8/23

2016/9/11

2016/10/30

2016/11/19

2016/12/10

D

2016/4/3

2016/5/3

E

2016/8/17

2016/11/25

2016/12/1

2017/1/1

F

2015/12/8

2016/1/8

G

2015/12/21

2016/2/2

2016/2/2

2016/4/12

2016/4/12

2016/6/12

2016/9/6

I

2015/12/1

2015/12/15

2015/12/15

2016/1/15

J

2015/3/3

2015/4/3

2015/4/7

2015/6/7

2015/6/2

2015/8/2

2015/8/18

2015/11/18

2015/11/13

2016/2/13

2016/2/9

2016/4/9

2016/4/28

<tbody>
</tbody><colgroup><col><col span="13"></colgroup>

Patient C, Patient D, Patient F, Patient I in this case would need reminder popups.

 

[My Aswer Is This]

What columns on your sheet need to be searched for dates?

What version of Excel do you use.

I think we need a comment to popup on the cell if date is past.

Does your version of Excel have comments?

 

[mdeza81090]

thank you for your reply.
here are the answers to your questions.

What columns on your sheet need to be searched for dates?
Columns J, P, V, AB, AH, AN, AT, AZ, BF, BL, BR, BK

What version of Excel do you use.
Excel 2010

I think we need a comment to popup on the cell if date is past.
I would like the comment/message to be: "Reminder needed"

Does your version of Excel have comments?
I dont know...

 

[My Aswer Is This]

What does this mean?

I would like the comment/message to be: "Reminder needed"

Right click on any cell do you see: "Insert Comment"

 

[mdeza81090]

I would like a popup window with the message "reminer needed".
This part is not so important, so you can ignore it if it is confusing, thanks.

 

[My Aswer Is This]

I could write a script to have a comment box popup on any cell with a overdue date. Would that work?

 

[mdeza81090]

thank you, yes that would be a possible solution.

the only thing is that that might be similar to conditional formatting?

i am looking for a solution to prevent the staff at the clinic from having to look through th entire excel sheet to see if a certain patient needs a reminder.

The ideal would be that something pops up to inform the staff that patient X,Y,Z needs a reminder because they are 7 days past their appt, evey time the excel file is opened.


please let me know if you need any more clarification.


thank you in advance

 

[My Aswer Is This]

Why don't we display a list of patient names in say sheet (3) column "A" with the names of all patients overdue. And have this sheet displayed first every time you open the Workbook.

Having 10 or so Popups on the screen telling you what patients are overdue and then having the patients name displayed on the Popup is not something I would know how to do. But someone else here at Mr. Excel may know how to do that.

 

[mdeza81090]

Thank you!!!

That would be perfect!