Display a message box when validation criteria is violated

[Nitehawkhp]

I’m trying to use a msgbox to provide instructions if validation criteria are violated. I’m able to get the validation configured, but I would like a different message box to appear when the entered data is outside the validation criteria.

For example, the validation criteria require the entered numbers must be >0 and <<entered amount="" <100.="" if="" there="" is="" an="" entry="" <0="" or="">100. If the entry is outside the criteria the default msgbox is displayed stating “This value doesn’t match the data validation restrictions defined for this cell.”

I would like to provide additional information stating that the entry must be <entered amount="" <100.
0 < entered amount < 100.
I don’t know how to do that type of thing.

Any help would be greatly appreciated.

Rod</entered></entered>

 

[Nitehawkhp]

Did you change A1 to J1?

Brain dead today...

Thanks that works perfectly!

Rod