Check cell for specific TEXT is match then CONTINUE WITH CODE

[HotNumbers]

How do i check a specific cell for example L15 for specific text if the text is correct then continue with rest of code if not a match then msg box with "Wrong Workbook Imported" and code Ends

 

[JoeMo]

How do i check a specific cell for example L15 for specific text if the text is correct then continue with rest of code if not a match then msg box with "Wrong Workbook Imported" and code Ends

Something like this:

If Range("L15").Value <> "Specific Text Here" then
     Msgbox "Wrong Workbook Imported"
     Exit Sub
End if

 

[HotNumbers]

something like this:

if range("l15").value <> "specific text here" then
     msgbox "wrong workbook imported"
     exit sub
end if

perfection!!!!!!!!!!!!!!