cdrobinson83
New Member
- Joined
- May 3, 2021
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Hello,
I am trying to write something that calls on another macro to run only if a cell contains certain text. But the text is actually a few different options; such as if the cell B2 contains apple or orange or banana then run call on the macro.
To make things more complicated, I would like to add to the rule that the tab name also does NOT contain certain text; also a list of values. So basically, I’d like the rule to be if cell B2 contains apple or orange or banana and the tab name does NOT contain carrot or corn or spinach, then call on the macro. And then move on through the rest of the current macro if the above statement is false basically. Is this a possibility?
I am trying to write something that calls on another macro to run only if a cell contains certain text. But the text is actually a few different options; such as if the cell B2 contains apple or orange or banana then run call on the macro.
To make things more complicated, I would like to add to the rule that the tab name also does NOT contain certain text; also a list of values. So basically, I’d like the rule to be if cell B2 contains apple or orange or banana and the tab name does NOT contain carrot or corn or spinach, then call on the macro. And then move on through the rest of the current macro if the above statement is false basically. Is this a possibility?