not found

Hello, I'm building a VBA form where I require only two fields to be typed, afterwards when hitting a record button, they are transferred into sheet1, now that works fine. In sheet2 ("RecordPrint") some data is previously filled, and I require that other cells in sheet1 VLookup data recorded in...

In one workbook, need to do a simple VBA match like this: Compare Col B (starting with row 8) of the PARTS tab to Col P (starting w/ row 5) of the MATERIALS tab. If match is found, do nothing, (continue to next row)... if NO MATCH is found, then highlight/fill the cell in COL P of the MATERIALS...

I have a code that searches one page for a value entered into a inputbox. Everything is working great if the result is found; if it is not found or is left blank it turns all my shapes on the page one color (which is part of the code at the bottom). I would like to simply exit the sub if there...

I am running Excel 2010 and writing code for Excel 2007 and 2003 users. I want to find if a value exists in Column D. The value is: **FAIL** (including the astericks). If it does exist, I want a "WARNING" message box to appear. If not, I want to continue with the rest of the macro. I tried...