how to check the duplicate data entry in form?

hi
Here i design the user form by help of this forum it work but it add the duplicate data so i want to code the from that check and than allow the user to enter the data.
actual user form have to take the data from the "Brought sheet" and add the newly added from data and save in the "records"W sheet .but before adding the data to "Record "W Sheet
it must check for duplicate data in "Record" W sheet if it find the same "ticker"symbol in "Record sheet" it will give the msg."Ticker already exist in records" then if still user want to add the data .form will allow the user to add data in "Record Sheet" by giving the msg."anyway Add the Ticker to Records" Yes or No option button. here i attech the work sheet which work without cheking the duplicate data by "Ticker"symbol pl help me to code the same
thanks

i hope i explain the way u can get what i want to do.

I believe this would do it. Under the Private Sub Enterdata_Click(), I include your top and bottom line where I inserted my code, below:

Please Login or Register  to view this content.

Does that work for you?

No problem. To protect the sheet originally, go to Tools -> Protection -> Protect Sheet.

Then when you are running the code, before you enter any data onto it, unprotect by:

Please Login or Register  to view this content.

Only include the Password argument if you put one on when protecting the sheet.

Then once you are finished entering data:

Please Login or Register  to view this content.

Thats all it takes.