show with messaje box when it's time and date

  • Thread starter Thread starter KM**VE
  • Start date Start date
K

KM**VE

HELLO FRIENDS NEED HELP
I HAVE THE COLUMN (A) The time to write date and hour Next notice /Alarm, I
need
Warn me when it's time and date of notice/alarm start up show with messaje
box
Message with the message that I write in the same row of column ( B) in the
same row
EXAMPLE:

A B
1 26/04/2010 10:00 AM payment LIGHT
2 03/05/2010 4:20 PM Remember payment Phone
3 06/04/2010 8:40 AM Appointment with Dr.

Saludo
KM**VE
 
hi, KM !
I HAVE THE COLUMN (A) The time to write date and hour Next notice /Alarm
I need Warn me when it's time and date of notice/alarm start up show with messaje box
Message with the message that I write in the same row of column ( B) in the same row
EXAMPLE:
A B
1 26/04/2010 10:00 AM payment LIGHT
2 03/05/2010 4:20 PM Remember payment Phone
3 06/04/2010 8:40 AM Appointment with Dr.
Click to expand...

I suggest the use of OnTime method (if you want to go with excel) or Outlook, so...

op1: use outlook as it is an application designed to handle appointments

op2: read all about the "how-to" (ontime) in this page:
http://www.cpearson.com/Excel/OnTime.aspx
and then adapt disregarding dates other than date (vba today's) function

regards,
hector.
 
Back
Top