Vba code - Automatically delete row based on keyword

[Neo45]

[FONT=&quot]HI,
[/FONT]
[FONT=&quot]Need to automatically delete row that contain certain keywords.
As an example -:
i have data sheet with 5 column.(Name,Last Name,Company Position,Email Address ,Phone Numbers )
If any of keywords are located in any cell (as part of a word, email, address, job title, company, etc,) need to delete the row automatically.
(keywords-loan,financial,bank,equity)

Thank you.[/FONT]

 

[Neo45]

Dear Fennek ,

Its working grate ,thank a lot your support.
your are valuable person of this forum.

 

[pijushroy]

Thanks for the Code, it helps me lot.
But I have check box in my excel, based on checked value, I need to run the VBA
So I don't want to fixed the value in "KeyW = Array("loan", "financial", "bank", "equity")", the value should come from selection of the check box
After selection of the check box, the value store in one cell or cell range.
I want to fetch the value to VBA and run the VBA
Please help me