1. Engineering
  2. Computer Science
  3. i need a vba code to search the word quothorrorquot...

Question: i need a vba code to search the word quothorrorquot...

Question details

I need a VBA code to search the word "horror" in the worksheet and then display message that lists all the horror movies in the worksheet?

screenshot of the worksheet below

FILM DATA ▼ Popular Awards BOOL Tie Me Up! Tie Me Down! Banderas, Antonio NicholasCage.png NicholasCage.png NicholasCage.png Dead Zone, The NicholasCage.png NicholasCage.png NicholasCage.png Octopussy Loma, Jasé Antonio de la American Angels: Baptism of Blood, The Subway Bergen, Robert D. Lambert, Christopher Depardieu, Gérard Adjani, Isabelle Adjani, Isabelle NicholasCage.png Fanny and Alexander Tragedy of a Ridiculous Man A Man & a Woman A Man &a Woman: Twenty Years Later Un Hombre y una Mujer Tognazzi, Ugo Trintignant, Jean-Louis Trintignant, Jean-Luis Trintignant, lean-Louis NicholasCage.png NicholasCage.png Lelouch, Claude Lelouch, Claude Aimee, Anouk Aleandro, Norma Lindbergh Kidnapping Case, The Hitchcock, Alfred alfredHitchcock.png Allen, eizabeth ohnWayne.pn NicholasCage.png Tucker: The Man & His Drean Coppola, Francis Ford Spielberg, Steven Glaser, Paul Michael Hopkins, Stephen NicholasCage.png Running Man, The Science Fiction Schwarzenegger, ArnoldAlonso, Maria Conchita Alonso, Maria Conchita Alonso, Maria Conch NicholasCage.png Cage, Nicolas NicholasCage.png glennFord.png NicholasCage.png Happy Birthday to Me Anderson, Melissa Sue Stern, Steven Hillard Altman, Robert Bergman, Ingmar Devlls Eye, The Wild Strawberries Seventh Seal, The Andersson, Bibl Sydow, Max von Bergman, Ingmar Bergman, Ingmar Bergman, Ingmar NicholasCage.png Andersson, Harrlet Naked Night, The Through a Glass Darkly Cries & Whispers Barbarlan & the Gelsha, The Bergmanpng Andersson, Marriet Ando, Elko

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution