1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Run VBA script if text string in cell matches text string in second cell

Our take

Are you looking to streamline your Excel tasks with VBA? If you're seeking a solution to trigger an action based on text string matches between cells, you're in the right place. In this scenario, you'll want a script that checks if the text in cell A1 matches cell B1. If there’s no match, it will then verify against cell C1. This approach allows for clear, conditional actions based on your specified criteria, enhancing your spreadsheet's functionality. Let’s explore how to implement this effectively.

Can someone help me with a VBA script? I need to perform an action if the text string in cell A1 matches the text string in cell B1, and if no match, then check if text string in cell A1 matches text string in cell C1, otherwise take no action.

submitted by /u/lctaylor2288
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article