Pop up box required

[ABU_HASAN]

Dear Sir

I make Invoice in excel and i need a pop up box with message "E WAY BILL REQUIRED" when below conditions are met

When Total INV VALUE cell "L44" >= 100001 and CGST Value cell "L42" =>1 then box should pop up

In the same Invoice
When "IGST" value cell "L40" >=1 and Inv Value "L44" >= 50000 then box should pop up.

Basically
1. box should pop up when igst cell is not empty and inv value is >=50000
2. box should pop up when cgst cell is not empty and inv value is >=100001

Kindly help!!!

 

[nemmi69]

Do you want it as a message box where the user clicks an "OK" button to clear?

 

[ABU_HASAN]

Yes

 

[nemmi69]

Do you already have any VBa code in use?

 

[ABU_HASAN]

Do you already have any VBa code in use?

Yes i have a vba code but i want this for a worksheet in general declarations

 

[nemmi69]

' make Invoice in excel and i need a pop up box with message "E WAY BILL REQUIRED" when below conditions are met
'
'When Total INV VALUE cell "L44" >= 100001 and CGST Value cell "L42" =>1 then box should pop up
'
'In the same Invoice
'When "IGST" value cell "L40" >=1 and Inv Value "L44" >= 50000 then box should pop up.
'
'Basically
'1. box should pop up when igst cell is not empty and inv value is >=50000
'2. box should pop up when cgst cell is not empty and inv value is >=100001


Sub MsgPopup()
If IsEmpty(Range("L40").Value) = False And IsEmpty(Range("L44").Value) = False Then
    If Range("L40").Value >= 1 And Range("L44").Value >= 50000 Then
        MsgBox "E WAY BILL REQUIRED", vbOKOnly, ThisWorkbook.Name
    End If
End If
End Sub

 

[ABU_HASAN]

' make Invoice in excel and i need a pop up box with message "E WAY BILL REQUIRED" when below conditions are met
'
'When Total INV VALUE cell "L44" >= 100001 and CGST Value cell "L42" =>1 then box should pop up
'
'In the same Invoice
'When "IGST" value cell "L40" >=1 and Inv Value "L44" >= 50000 then box should pop up.
'
'Basically
'1. box should pop up when igst cell is not empty and inv value is >=50000
'2. box should pop up when cgst cell is not empty and inv value is >=100001


Sub MsgPopup()
If IsEmpty(Range("L40").Value) = False And IsEmpty(Range("L44").Value) = False Then
    If Range("L40").Value >= 1 And Range("L44").Value >= 50000 Then
        MsgBox "E WAY BILL REQUIRED", vbOKOnly, ThisWorkbook.Name
    End If
End If
End Sub

Thanks a lot it works