Nitehawkhp
New Member
- Joined
- Dec 2, 2016
- Messages
- 37
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>
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>