Not found message

[ledzepe]

Hi everyone and thanks in advance for any help.

I made a macro to search for string inside a worksheet. However I can't make my not found message come up. Below's my code

If Cells.Find(What:=CustName, SearchFormat:=False).Activate Then
do whatever
else
msgbox "Customer Name not found!"
end if

I'm not a vb programmer so please correct my code.

[Carim]

Hi Ledzepe,

Something along these lines

Please Login or Register  to view this content.

HTH
Carim