Pop up a message box based on values of a range

[ramakavin]

Hello Guys,

I have a range of values in H23:H37 (1 for yes, 0 for no). This range basically determines if there are empty cells in the range B23:F37. Ie if in the row B23:F23 there is an empty cell, H23 will contain 0.


I have a macro which will perform some actions which is activated by a button.

I would like to pop up a message box if a value in the range H23:H37 is equal to 0 when the button is pressed. I would like to indicate the row or rows in which the 0 value is present so that corrections can be made by the user.

Could you help me achieve this please?

thanks in advance for ur help

[royUK]

Try adding this to the start of the code

Please Login or Register  to view this content.

[ramakavin]

Thanks a lot Roy, this perfectly works.

I got another question though i am not sure about which forum is the correct one to ask this question.

I keep getting a pop up from excel

"Privacy warning: this document contains macros, Activex controles etc..These may include personnal information that cannot be removed by the document inspector".

I saved my file as .xslm but it this message is still pestering me..

would u know how to turn this off?