Question: 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

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

I need a VBA code to search the word "horror" in the

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, Grard 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 Devll's 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Liting Wang Shelly Cashman Excel 2013 Chapter 10: SAM Project 1a Submission #2 Score is 79 out of 100 1. Go to the Event Schedule - 2018 worksheet and use the password J@Nuary18 to unprotect the...

PROJECT DESCRIPTION Patrick Fitzgerald is the director of Career Development at Finn Technical Institute, a local community college. The Institute offers workshops on resume writing, interview...

Exp19_Excel_Ch03_CapAssessment_Movies_Instructions (Protected View) - Word ogs Review View Help Tell me what you want to do less you need to edit, it's safer to stay in Protected View. Enable Editing...

Introduction The IMDB ( Assignment 2 . xIsx ) data shows the top 1 0 0 0 movies rated on the website IMDB. You will be describing the data using summary and statistics functions as well as creating a...

Search Scor Dumns - Anna P 9-18 Durr_exploring_co_grader_21 - Protected View Flc Home Insert Draw Page Layout Formulas Data RAVICH View Help O PROTECTED VIEW Be careful files from the Internet can...

#Chapter 1: Data entry, name and group worksheets, formatting, sorting and filtering, page layout, and forms. Business Problem: How might a manager track inventory quantities-on-hand? #Chapter 2:...

i have attache the excel assignment. can you please complete this and help me out? Instructions: The following assignment is a 4-part tutorial on more advanced and useful techniques in Excel for data...

QUESTION 9 1 In Microsoft Excel, what is the primary purpose of a Pivot Table? a . Pivot Tables are used to filter and sort data, providing a quick overview of information in a worksheet. b . Pivot...

Hi, I'm having an issue with this Simnet project and I was wondering if anyone could help me. There is only one issue: Step 3a, in the instruction pdf that I have attached. When my project is graded...

Lucky Enterprises deals in furniture &fixtures. Its stockholders equity accounts with balances on January 1, 2020 are as follows: Common Stock, $20 stated value (500,000 shares authorized, 375,000...

Q.1. Let's practice the concept of polyphase decomposition of a sequence. Consider the following sequence: [10] CLO 3 h[n] = 2n + 1 0n7 a) Consider M = 4 and pass h[n] through the block diagram shown...

The financial report assertion of existence is concerned with ensuring that , A a transaction or event that relates to the entity actually took place during the period B assets, liabilities, and...

Part A (13 marks) Management accounting is increasingly becoming a critical decision-making process in organizations across the world. In this task, you are to evaluate the future of management...

What world or national events have taken place during your lifetime?

If, as McGregor suggests, managerial competence is created on the job, what is the role of classroom learning?

How can classroom learning be designed to ensure that each student is motivated by his or her felt needs for new learning rather than using a one size fits all approach?