Reminder

[rbacon100]

Hi all!

I am not sure if that is possible, but I will ask.

I have in column A reminders, for example, "someones bday", or "someones aniversity" or whatever. In column B there are dates.

I want to make a macro that will when I open workbook it pops up reminder 4 days and less to remind me about some date.

For example. In 4 days will be someones bday.

I want that when I open workbook it shows, "someones bday" in 4 days. And tomorrow same thing just in 3 days. And when that date comes just to show "someones bday"

So basically. If date in column B is in 4 days, that it pops up what it saying in column A next to that date.

Also if more then 1 reminder is there it will look like this.

"Someones bday" in 4 days
"Someone else bday" in 3 days
"Someones aniversity" in 4 days. Etc, depends on dates.

Is that possible?

I tried to find it around, but I couldnt

 

[Claus Busch]

Hi,

Am Thu, 29 May 2014 00:28:45 -0700 (PDT) schrieb (e-mail address removed):

So basically. If date in column B is in 4 days, that it pops up what it saying in column A next to that date.

what dates do you have in column B? This years dates or the real
birthdates?


Regards
Claus B.

 

[rbacon100]

Hi,



Am Thu, 29 May 2014 00:28:45 -0700 (PDT) schrieb (e-mail address removed):






what dates do you have in column B? This years dates or the real

birthdates?





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

Thanks for reply.

This year dates. For example 5/31/2014 for bday. I need just for this year.
But as I said, there arent bdays only, there are aniversities and other stuff. Thats why I need reminder to pop up what is saying in Column A.

Thanks

 

[Claus Busch]

Hi,

Am Thu, 29 May 2014 02:07:14 -0700 (PDT) schrieb (e-mail address removed):

This year dates. For example 5/31/2014 for bday. I need just for this year.
But as I said, there arent bdays only, there are aniversities and other stuff. Thats why I need reminder to pop up what is saying in Column A.

please have a look:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for "Reminder"
You have to rightclick and download the file because marcos are disabled
in OneDrive.
On sheet CF I have a suggestion with Conditional Formatting.


Regards
Claus B.

 

[rbacon100]

Hi,



Am Thu, 29 May 2014 02:07:14 -0700 (PDT) schrieb (e-mail address removed):







please have a look:

https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326

for "Reminder"

You have to rightclick and download the file because marcos are disabled

in OneDrive.

On sheet CF I have a suggestion with Conditional Formatting.





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

This is perfect. Thank you alot.

Also. About conditional formatting. I had like that before, but thing is because I have big list for whole year, I needed to scroll down to see if something soon will come.

But this what you did with macro is amazing. Thanks for that. You are awesome.

 

[Claus Busch]

Hi,

Am Thu, 29 May 2014 03:17:39 -0700 (PDT) schrieb (e-mail address removed):

Also. About conditional formatting. I had like that before, but thing is because I have big list for whole year, I needed to scroll down to see if something soon will come.

But this what you did with macro is amazing. Thanks for that. You are awesome.

thank you for your feedback.
Please have another look. I did some corrections.


Regards
Claus B.

 

[rbacon100]

Hi there again.

Sorry for late reply. It is perfect, thanks.

It is awesome with conditional formatting too, but I like more with code.

Thanks again, you are awesome!