To check in a column a certain criteria meets and display dialog box

Hi All,

I have coloumn B with codes represent regions.. which all are in numbers like 321,546,231,895,125, etc...

in this i need a macro to check certain codes 504,556,943...etc, if any of these codes available it should display a msg box saying "There are major codes" with vbokcncl.. if those major codes are not trhere it should display as "There is no Major codes"...

I tried it with IF and simple msgbox but i failed..

Appreciate your work i thisa thanks... For your refernce i have attached a sample excel.

Can you not do by an Excel Formula?
=IF(ISERROR(MATCH(B2,$D$2:$D$4,0)),"N","Y")

Hi natahnsav... Thanks.....

Hi John,

Thanks.. works fine... But i expected a simple macro which says only if the major code available msgbox "There is major codes" and if no msgbox as "There is no Major codes"

Thanks expecting reply......

Hi, Bala,

maybe

Please Login or Register  to view this content.

Ciao,
Holger

Hi HaHoBe,

Thanks...

Have a query and need a solution.. lets forget about the example excel i have uploaded...

I have 1000 random number in column B, if the random number list contains any of these "558", "546", "766", "564", "566", numbers, Msg box should display as "There is codes in the list"and if there is no above said numbers present then msgbox should display "There is no codes in the list"...

Thanks....

Hi, Bala,

sorry, I donīt understand what you are after. The code supplied does what you requested, if you want anything changed you would need to put that in words.

Ciao,
Holger

Hi HaHoBe,

I have attached a fresh excel with clear information... Hope am clear this time... Thanks a lot...

Hi, Bala,

These are major codes, actually it wont present in excel these numbers in D column is only for reference…

The code I supplied still comes up with what I understood from your request, and I canīt understand what you are asking for now.

Ciao,
Holger