Messege boxs
 

please i need a help on this case.
i have a data about products on sheet1
and i want excel to remmembering be about products that will expired berfore
30 days in a message box that contain the products and its dates which will
expired after some day but not more than 30 days
thank you in advance

Messege boxs
 

I would not do it with a message box - it has the disadvantage that all
messages popping up needs to be acknowledged.

Why don't you do it with conditional formating?
All dates expiring in 30 day will be marked red and bold for instance.



"F.M.H" wrote:

please i need a help on this case.
i have a data about products on sheet1
and i want excel to remmembering be about products that will expired berfore
30 days in a message box that contain the products and its dates which will
expired after some day but not more than 30 days
thank you in advance

Messege boxs
 

I agree,
Just add an extra column with a function as below:
for example, if the expiry dates are in column "D" then in cell E2 put:
=E2-today() [formatted as 'general']
Then apply conditional formatting to column "E" so that anything at 30 or
under shows as red text for example
Hope this helps



"Franz Erhart" wrote:

I would not do it with a message box - it has the disadvantage that all
messages popping up needs to be acknowledged.

Why don't you do it with conditional formating?
All dates expiring in 30 day will be marked red and bold for instance.



"F.M.H" wrote:

please i need a help on this case.
i have a data about products on sheet1
and i want excel to remmembering be about products that will expired berfore
30 days in a message box that contain the products and its dates which will
expired after some day but not more than 30 days
thank you in advance

Messege boxs
 

thanks a lote for you Mrs. David, Franz Erhart for replying fast but i have
alot of dates and i need it to apear on message box and the dates that will
expired after 30 days listed on this message box
thank you in advance
F.M.H

"David" wrote:

I agree,
Just add an extra column with a function as below:
for example, if the expiry dates are in column "D" then in cell E2 put:
=E2-today() [formatted as 'general']
Then apply conditional formatting to column "E" so that anything at 30 or
under shows as red text for example
Hope this helps



"Franz Erhart" wrote:

I would not do it with a message box - it has the disadvantage that all
messages popping up needs to be acknowledged.

Why don't you do it with conditional formating?
All dates expiring in 30 day will be marked red and bold for instance.



"F.M.H" wrote:

please i need a help on this case.
i have a data about products on sheet1
and i want excel to remmembering be about products that will expired berfore
30 days in a message box that contain the products and its dates which will
expired after some day but not more than 30 days
thank you in advance