Prevent Duplicate Customer Names

[billy60]

Hello,

On the Schedule sheet there is option to add new customer with VBA and then option to save. How can this prevent a duplicate customer name?

Also can the customer selection drop down be in last name alphabetical order please?

Any help or suggestions would be appreciated.

[JohnTopley]

Looking at the code, you do not appear to differentiate between (Or have the ability to) a NEW contact and UPdate to an existing customer

so perhaps you need think about this.

For duplicates, I would simply do a "Lookup" on the customer list, using customer name.

[billy60]

I should have changed the sheet name 'Customers' to 'Contacts'. I was trying to combine features from different workbooks.

[billy60]

I should have asked for a way to check if that customer exists in the system (Contacts sheet). I will try to figure it out sorry for the trouble.

[JohnTopley]

You could use COUNTIF to check if it returned 1 which indicates the customer already exists.

[billy60]

I have no idea how to do that in the save code.

[skywriter]

Please Login or Register  to view this content.

[billy60]

Thank you I will try in the morning.

[JohnTopley]

in sheet "Schedule"

Please Login or Register  to view this content.

[MikeVol]

Also as an option:

Please Login or Register  to view this content.

Write the given code to the Schedule Sheet Module. Good Luck.

[billy60]

I tried John Topley's solution. There is an issue though. The calendar has appointments that can be selected to show the details of that appointment. When clicking the popup shows that customer exists.

[jindon]

billy60

Prevent Duplicate Customer Names

Is it like that simple?
If you are managing Appointment not to overwrap for the Customer then
1)
Insert bold lines in "Sub Appt_SaveUpdate"

Please Login or Register  to view this content.

2) Add below to the same code module

Please Login or Register  to view this content.

3)

Also can the customer selection drop down be in last name alphabetical order please?

Add following lines in Schedule Worksheeet_Activate event procedure.

Please Login or Register  to view this content.

All above is assuming your other part of codes are all working correctly.