Message Box if certain value is entered

[Guest]

Hi,

I have a list in a worksheet "Clients",
this includes
1) ABC
2) SHELL
3) CHEVRON
........
The list actually includes 50 clients.

In cell A1 of Worksheet "Summary" if someone enters a Client in this list
a message box should prompt "This is a key Client"

The slight catch is, if someone enters a derivative e.g. ABC Ltd, ABC
Worldwide, ABC Co, the message box should still appear .

Thanks

 

[Bob Phillips]

see other thread.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)