Pop Up box
 

Hi Randy,

You can do this with Data | Validation. Just select row 2, select Data |
Validation, then select Custom and enter this formula:

=COUNTIF($2:$2,"=" & A2)=1

Under the Error Alert tab, you can enter the error message you'd like
displayed when users enter bad data. Unfortunately, copying/pasting will
destroy the data validation, so this will not stop someone from
copying/pasting data onto row 2.

--
Regards,

Jake Marx
www.longhead.com


Randy wrote:
When entering a cell value and a dupilicate exists in the
same cell different column, I would like a pop up that
says "Please Enter a Unique Value"
All help would be appreciated
Thanks!

Pop Up box More Help please
 

I would like to add this to an existing macro that I am
already using
Thanks!
-----Original Message-----
Hi Randy,

You can do this with Data | Validation. Just select row
2, select Data |
Validation, then select Custom and enter this formula:

=COUNTIF($2:$2,"=" & A2)=1

Under the Error Alert tab, you can enter the error
message you'd like
displayed when users enter bad data. Unfortunately,
copying/pasting will
destroy the data validation, so this will not stop
someone from
copying/pasting data onto row 2.

--
Regards,

Jake Marx
www.longhead.com


Randy wrote:
When entering a cell value and a dupilicate exists in
the
same cell different column, I would like a pop up that
says "Please Enter a Unique Value"
All help would be appreciated
Thanks!

.