VBA Excel For Next If Else Loop Statement Using Like Operator to Pull Image and Text
This VBA Excel, For Next, Loop Statement allows users to type up to six names to search for; for each name typed that matches name range, the code wil pull an image into the spreadsheet from the Picture folder that applies to that name. The loop will only show action for matching data/names that user types into specific cells. There will be no activity when names aren't typed by user or if names don't match.
This code can be enhanced to take into Marketing, Sales and Advertising Meetings. It can even be used to pull products, their summary and an image of the products along with prices, just like you'd do with JavaScript while view sites like Amazon or other online retailers. It can be used in Law Enforcement to pull iimages of suspects' image and names that fit a specific profile.