$$Excel-Macros$$ User form Find code to ignore if text box is blank

2013-04-15 Thread Thomas Yantorno
Hello, I have code that looks to modify a cell when there is a value placed in a user form. My issue is that there are multiple text boxes in the user form and I only want the user form to update the cell if there is a value, but ignore a text box if there is no value. Currently, it will update

$$Excel-Macros$$ Blank out corresponding column if multiple criteria found

2013-01-31 Thread Thomas Yantorno
Hello All, I have code that will look through column A for the string AL and if it if found will blank out column B if there is a value in the cell in the same row as column A. What I have been trying to do is perform same procedure but is there a way I can use multiple states, e.g. Look to