I have an input field where a user can copy/paste Shipment ID's and click the 'Search' button to query the data on ShipmentID. However, if the user searches for a Shipment ID that does not exist, nothing happens. Instead, I would like a macro to run when the 'Search' action is executed that will open a message box telling you if one or more ShipmentIDs from the input box were not found in the field. Is this possible?
I have included an example file so that this question will make more sense. Thank you for the help.