message box

[Rajendar]

Dear Sir,

I need your help in creating msg box in vba


Please Refer the column “S” when I enter the issue Qty , if there is a item code in column “N” also refer the column “I” is blank I need message box “ MIV Number Missing “ and should not allow to enter issue Qty


If column “N” is blank no need any message box no need any restrictions.

For your understanding attached excel sheet

 

[PCosta87]

Dear Sir,

I need your help in creating msg box in vba


Please Refer the column “S” when I enter the issue Qty , if there is a item code in column “N” also refer the column “I” is blank I need message box “ MIV Number Missing “ and should not allow to enter issue Qty


If column “N” is blank no need any message box no need any restrictions.

For your understanding attached excel sheet

Hi,

Please refer to attachment

I specifically set the range "S3:S20" as the range where the macro works but you can change it as per your need

Hope it works as intended

 

[Rajendar]

Thank you

 

[PCosta87]

Thank you

You are welcome