Need popup

[tasneem04]

i would like excel to generate an popup alert if ANY of my cells from E3:H16 is less than Number 40. Even I don't know how to enter in VBA script mode. I am new to xcel. Please advise. Thanks

[jraj1106]

Hi.

What if the cells are blank? Do you want the popup to appear if its blank?

Check the code below. If blank I m not showing the msgbox. Pls do confirm if its ok.


POPUPMSG.xlsm

[tasneem04]

No, there is no message. Please resend it.

[jraj1106]

Check this:

POPUPMSG.xlsm

[HaHoBe]

Hi, jraj1106,

any explanation for the TO on how to run the macro would be welcome:

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

@tasneem04:
Are the cells filled with formulas or is the data entered directly into the cells?

Ciao,
Holger

[khateeb]

cell data is dependent on other sheets data... And Do, I have run the Macros every time I need to check. Canot this MACROS be automatically turned ON when the workbook is opened.
Thanks Jraj n HaHobe

[HaHoBe]

Hi, khateeb,

if the data is coming in via Query the macro could be run at the end of the import. Or the Worksheet_Calculate-Event could be used for checking if Excel started a recalculation (I think you would need to add a volatile function to the sheet as well).

BTW: khateeb = tasneem04?

Ciao,
Holger

[tasneem04]

sorry, to be off the desk... yes its me only.... tasneem khateeb....
Anyways.. Thanks to all of you... My issue has been resolved.... thanks once again

[tasneem04]

Sheet summary2 has the table. And I am looking to compare and add the data (from all sheets Date 1 to Date31) . I am looking to add those values (yes as 1) in my summary 2 sheet for the range E3 to H14…