Thread: Pop Up box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Randy[_9_] Randy[_9_] is offline
external usenet poster
 
Posts: 2
Default 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!


.