Message box that pops up if values in array are <=0

**emoandy05** · 06-13-2012, 09:55 AM

Hi,

I have an array of values ("D4:D46") within a particular worksheet ("Countdown"), whose value depends on a formula and will update daily. If any of these values in the array are less than or equal to zero (<= 0), I would like a message box to appear reading, "Updates are available."

I would like this message box to only appear once each time the Excel file is opened.

Any help would be greatly appreciated.

Thank you.

**Steffen Thomsen** · 06-13-2012, 10:03 AM

Hi,

Try this

Please Login or Register  to view this content.

The code goes into the thisWorkbook code module

**emoandy05** · 06-13-2012, 10:14 AM

Hi, thanks for the fast response.

When I change the ref to match my sheet, do I just replace the (1) with ("name of my sheet")?

Also, to paste the code in the thisWorkbook module, can that be done by right clicking on the sheet tab, clicking view code, and then pasting it in there?

Thanks for the help. I'm new to vba.

**TurksMeister** · 08-24-2012, 12:33 PM

Hi There

This looks like it will solve my problems too, but dont understand how to change the (Sheet(1)) bit to my sheet name "Current Week". Anyone able to help?

Many thanks

Ta