Message box based on date in Excel

R

ritzzz

Joined
Mar 29, 2006
Messages
2
Reaction score
0
Hi, I need some help here.
I need a message box to pop up based on a date. e.g. if today is 3 days before the date stored in column C, then message box will pop up: "Need to collect payment from customer A". Customer names are stored in column A.

Col A(name) Col C (end period)
XYZ 4/4/06

So if today is 4/2/06, the message box will show: "Need to collect payment from XYZ"

I greatly appreciate your help.
 

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

Similar Threads

Auto fill for dates? 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Macro to send email 5 days before a date mentioned in Cell 1
3 results possible on every day. add up the number of each on each day. 2
Conditional formatting based on dates 1
Sort and create a Table of one column of dates 2
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
show with messaje box when it's time and date 1

Back
Top