How do i send pop up notification in excel when item quantity reaches minimum threshold

Question

How do i send pop up notification in excel when item quantity reaches minimum threshold

Answer 1

Hi,

You can try to use the Data Validation to get the result you need.

Select the Range you need- go to Data- Data Validation- Settings tab- Select Whole number and enter the Minimum number and the Maximum number:

Select Error Alert tab- enter the Title and Error message you need to pop up:

The Result will showing:

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

---

If the response is helpful, please click "Accept Answer" and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

You can use a combination of VBA code and Excel events.

Here's a basic example-

1. open your VBA Editor.
2. Insert a New Module.
3. Paste this code-

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim threshold As Integer
    
    ' Set your minimum quantity threshold
    threshold = 10 ' Adjust this value as needed

    ' Check if the changed cell is in the quantity column (assume it's column B)
    If Not Intersect(Target, Me.Columns("B")) Is Nothing Then
        ' Check if the new quantity is below the threshold
        If Target.Value <= threshold Then
            ' Display a pop-up notification
            MsgBox "Item quantity is below the minimum threshold!", vbExclamation, "Low Quantity Alert"
        End If
    End If
End Sub

Adjust the threshold value as per your need.

Then Close the VBA Editor and save your Excel file as an .xlsm.

Regards,

Tanay