Hi,

I want to create a VBA message box that generates as follows:

If the value in column X = "No" and then a value is inserted into column AH a dialogue box will appear stating "WARNING - X = No." This would logic would be applied to all cells in X and AH.

I would use Data Validation normally, but one of the cells already has Data Validation applied.

Can anyone help?

Thanks