Program "New Entry" button to prompt when there is a duplicate data.

[ariffinaldo]

1.) How do i program the New Entry button to prompt me when there is a duplicate data in the "Data" sheet of the workbook. Duplicate data means when both the Hull Number and the Shipyard Built is the same.

2.) How can i program the VBA code for the search button to check both shipyard built and hull number instead of just Hull number now.

3.) I have a "Other" included in my userform but i am unsure how to program it. For example, if a user press "other shipyards" in the dropdown menu for the shipyard, he will be prompted to enter the shipyard name in the "others" field instead.

3) How can i protect the Excel sheet such that people can only press search and new entry and unable to goto "Data" sheet.

Finally.. I have very little knowledge in VBA and i managed to come with this code from ebooks and several other programs.

[nathansav]

great place to start learning.

point 1

I would do an if application.worksheetfunction.countifs >0 based on your columns and criteria.

Use sumifs in the sheet to see how it works, then you can code it.

point 2

have a hidden column, concatenating the 2 searchfields, and concatenate them in your code before the find, so "shipyard1Hull1" and a formula of something like "a1&a2" in the data sheet

point 3

look at the .visible property of comboboxes and use the form initialise to set the form up for users.

[ariffinaldo]

Thank you. I will look into those.