Create if statement with two parameters

[RinorM]

Hi! I have the following code:

Please Login or Register  to view this content.

But the msgbox still appears when the C32=0

I want so that if C32>0 and D219="" then the message box will appear, otherwise if the cell C32 = 0 then messagebox should not appear.

Have I written anything wrong? thank you.

[pareshj]

Hi,

It is working fine 100%
Even if you are getting msgbox when C32 = 0, then debug the code and check the value of range C32.


Regards,
Paresh J

[pareshj]

Hi,

It is working fine 100%
Even if you are getting msgbox when C32 = 0, then debug the code and check the value of range C32 and D219.


Regards,
Paresh J

[stnkynts]

The way you have it written should work just fine. It probably has something to do with the format of the cell, the other range value, or you aren't looking at the correct cells.

[RinorM]

Oh now I see, I made a mistake. I wrote down the wrong Sheet. It should be:

Please Login or Register  to view this content.

I linked the wrong sheet, I was working in the sheet Indata. Anyway its fixed now.

Thank you for the help!!