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>

 

[Fluff]

Simply click on the "Error Alert" tab in the DV & enter your message in the "Error message" box

 

[mumps]

When you configure the data validation, you will see a tab that says "Error Alert" . Type your message in the "Error message" box.

 

[Nitehawkhp]

Thanks! That's almost too easy.

However, I just discovered an error in my validation formula...

How do I set it up so it will check for greater than 0 and less than 100 for valid entry?

 

[mumps]

Try:
=AND(A1>0, A1<100)

 

[Nitehawkhp]

Mumps,

That didn't work.

Rod

 

[mumps]

What range of cells has data validation?

 

[Nitehawkhp]

I'm using all of column J and I put the formula you gave me in the custom validation section.

 

[mumps]

Did you change the cell reference? =AND(J1>0, J1<100)
It worked for me.

 

[Fluff]

Did you change A1 to J1?