Msgbox to present values not found

**pedrofogao21** · 03-26-2012, 01:43 PM

Hi guys,

If I have the following data

Instrument Price
ENI US 17.63
EOC US 44.35
VALE US n/a
CIB US 59.56
EBR US n/a

Could anyone please help me create a msgbox that would return something like the following:

"Unable to find price for VALE US and EBR US"

Thanks in advance!!

**Dennis7849** · 03-26-2012, 01:57 PM

There needs to be some trigger for the msgbox to appear. This also means that there must already be a macro running too.

**pedrofogao21** · 03-26-2012, 02:25 PM

Yes, I understand.

That is what I am looking for: a code that would search the entire column B for "n/a" and in the end display a msgbox with the corresponding values in column A.

Thanks Dennis

**tkowal** · 03-26-2012, 02:48 PM

Dennis is absolutely correct -- you need a trigger.

In the attached workbook, I took a guess at what you wanted. I provide two ways (of many) of getting this information across to your user.... one with no code and the other with vba....

messagebox.xlsm

**Dennis7849** · 03-26-2012, 03:00 PM

Originally Posted by pedrofogao21

Yes, I understand.

That is what I am looking for: a code that would search the entire column B for "n/a" and in the end display a msgbox with the corresponding values in column A.

Thanks Dennis

If you have many instances of "n/a" showing up, the msgbox thing will get very annoying for the user.