Basic duplicate needed please

[ipbr21054]

Hi,

I am looking for a basic duplicate code so when i leave a specific cell the code would run.

So my new code should work like this.

Worksheet is called DATABASE
Cell where i would type the customers name is always A6
Once i leave cell A6 the code should check for a duplicate in only the Column range A6 & down the page.
If no duplicate is found then allow me to continue.
If a duplicate is found then show a msgbox yes / no asking would i like to be taken to that cell where the duplicate was found.
No just closes the msgbox where yes would take me to the cell where the duplicate is.

Thanks

 

[ipbr21054]

Now that works.
I see the msgbox & select yes.
I am then taken to the cell in question.

Can we please have the cell taken to RED & also apply the Ucase code from the original.

many thanks & another job well advised.

 

[My Aswer Is This]

You said:

Can we please have the cell taken to RED & also apply the Ucase code from the original.

Taken to Red?? What is Red.

And I do not know what the original code is suppose to do.

You said you did not know what it is suppose to do.

I cannot work with code that you do not know what it is suppose to do.
​

 

[ipbr21054]

Once taken to the duplicate cell have that cell shown in red.

Apply ucase code so all text etc on the page will change to upper case should small case be applied

 

[My Aswer Is This]

Well this keeps getting to be more and more.

In your original post you never mentioned wanting the interior color of the cell turning red.
And you never mentioned anything about wanting all value on the entire sheet to be in Upper Case

So you now saying when any value in any cell in the entire sheet is changed you want the value to be upper case. Is that true?

And what else might you want?

 

[ipbr21054]

Ok leave it thanks.

I will take a look at it

Thanks for your time

 

[My Aswer Is This]

I like helping users but when users do not spell out all details then it gets complicated.

Like turn cell Red. But then after this happens turn cell color to white.

It's always good to know what the overall objective is.

Like if cell value is a duplicate why go to the cell and why turn it red. How does this contribute to the ultimate goal.

What is the ultimate goal of what this sheet does?

 

[ipbr21054]

I didnt know what you were going to write so i didnt know how it would look.

I have learning issues so sometimes these things dont always spring to mind.

I would like if you have time the cell A6 to be uppercase & when i click on OK to the msgbox & taken to the duplicated customer cell have it shown in Red as the opposed colour it is so it stands out better.
Once you then continue with your work the RED should change back to its origianl state of which was YELLOW

Thanks,if you dont have no time then no problem.

Have a nice day

 

[My Aswer Is This]

Edit

 

[My Aswer Is This]

So only Range("A6") is Uppercase

And what does this mean?

Once you then continue with your work the RED should change back to its origianl state of which was YELLOW

So if you do anything else on the entire sheet the duplicate cell range should turn Yellow.


​