Macro to open message box

[#1]

Hi All,

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.

[#2]

As an added challenge for you QlikView wizards, it would be ideal if the Message Box would say "The following ShipmentIDs were not found:" and then list the entered values not found in the field.

[#3]

hello , see my file. its should be what you are looking for

hello marchetto

[#4]

That's further than I got on this. I would still love to have it show which values were not found, but I don't know where to begin on that... Thanks for your help, Marco.

[#5 · Accepted solution]

keep this

[#6]

Awesome! Thank you very much!!

[#7]

figured.

So in this documet there isn't a input filed,but input box

[#8]

Doesn’t look like it recognizes when some parts are null and some aren’t though?