Searching cells in multiple worksheets

I'm trying to get VBA to look at a particular cell across several worksheets and to put up a message (or carry out another function) if the information in any of the cells is not correct. Cell Z38 can have certain text in it or it can be empty, but anything other than that it needs to tell me which sheet (Entry Form) has the different text in.

I've built the following code, but it always returns "New Team in Entry Form 1!" regardless of which form's cell Z38 I put the different wording in. (I'm only trying out 4 sheets at the moment). I've tried removing the .Value from Form (1) IF, but it makes no difference.

(There are suitable End If's after this lot too)

Any ideas please??

Please Login or Register  to view this content.

You test

Please Login or Register  to view this content.

no matter what is in that cell it is either diffrent from "" or different from "New Team Name" (orsometimes different from both). So the crriteria is always true and you always get first Msgbox

The solution: Test

Please Login or Register  to view this content.

and the same way other criteria.