Hello,
I have this strange problem with my code and i just can't seem to figure out the issue.
The code below is situated in a userform and when a customer is selected from the combo-box drop-down the code checks whether the customer exists in my "customer database" which is one of the tabs on my excel workbook.
So if the customer exists then the code writes the customer into the active sheet (not the customer database sheet), and if the customer does not exist then the code prompts the user with the following: "This customer is not in the customer list. To automatically add this customer to the list click Yes." When "yes" is selected the code adds this customer to the customer database and adds the customer to the active worksheet.
The issue i am having is very strange, most times the customer gets added to the activesheet, but sometimes the customer does not get added.
i would really be grateful to anyone who can help me solve this problem.
This code is Before update event
This event (which belongs to the same combo-box) is a change event
Bookmarks