show with messaje box when it's time and 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
 
H

Héctor Miguel

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top