Preventing Duplicate Entries

Hi

I have a userform where users enter data and select a date and a time

Worksheet ("CVdata")
Column A = Date
Column B = Time
Column C = Gen Debt

Userform
Date text box = CVdate
Time comboBox = ComboBox1

I want to add a code in my Add data button which will prevent users from entering data which has the same Date and Time as a record on my worksheet

Looked through the forums but cant seem to find an example of this, Please help?

try this:

Please Login or Register  to view this content.

Hi Thanks for replying

Unfortunately the above code results in error

Need the code to check if a record being entered has the same Date(CVdate) & Time(ComboBox1) as a record on my sheet(CVdata)

Sorry to bump. any help please?

Still had no luck, anyone please help?

Anyone? please

Please Login or Register  to view this content.

Hi Thanks for replying, again it is still allowing me to enter data with the same date and time as a record on my sheet "CVdata"

This is my current button code for adding records

Please Login or Register  to view this content.

Want to add a code to this to prevent users from entering duplicate data (Same Date and Time)

Any Ideas?

upload your file.

Copy of dashboard attached

Perhaps something like ..............

Please Login or Register  to view this content.

Works perfect, You legend, thank you so much have made my day