VBA Message Box

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

Thanks for responding!

I've not used a Worksheet Change Event Handler before. I've found some example code online, but not sure how to add the conditional monitoring of cell X...


Private Sub Worksheet_Change(ByVal Target As Range)



If Target.Address = "AH$13"

MsgBox "This Code Runs When Cell A1 Changes!"

End If


End Sub

Please Login or Register  to view this content.

Artik

It works! Thank you so much for your help!