Excel cell validation

[ron513]

I need assistance with coding cell validation. In a worksheet I want the user to enter a value in one of two cells, a value cannot be in both. Also a message box would be display indicating the error to the user.

Thanks

Ron

 

[AnotherHiggins]

Have you looked at Excel's built in Data > Validation?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[ron513]

I have, but could not apply it to my situation, although it could be my inexperience.

Ron

 

[SkipVought]

the occurrence count cannot be greater than ONE. The range is the two cells.

Checkout the COUNTIF function.

Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[AnotherHiggins]

Let's say that the two cells in which someone may enter data are D2 and D4.

Select those cells, go to Data > Validation, On the Settings tab choose Other, type in
[COLOR=blue white]=CountA($D$2, $D$4) < 2[/color]

Configure the message box however you want on the Error Alert tab.



[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[ron513]

That’s it, thanks John.

Ron

 

[AnotherHiggins]

'Glad we could help


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.