Value doesnt match the data restrictions

[excelformanda]

Good morning everyone,

I downloaded a customer manager from the internet with a vba mask to input customer data. In order to facilitate the input of customer data I created a list for one data input cell which is linked to a dynamic range in the customer data worksheet. Now I have the problem that I can only choose values from the list to put into that specific cell and no longer can differentiate whether I want to choose from the list or write a new value into that cell which is not already on the list. How can I do both?

Regarding to the screenshot:
Whenever I have a customer to which Type 1, Type 2 or Type 3 applies, I want to choose it from the list and whenever I have a customer to which one of these types does not apply I simply want to write Type 4 into that cell (or whatever) and it gets copied over. How can I have both?

Many thanks in advance for your help!

 

[RoryA]

Uncheck the error alert option in the Data Validation settings:

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Value doesnt match the data restrictions

Good morning everyone, I downloaded a customer manager from the internet with a vba mask to input customer data. In order to facilitate the input of customer data I created a list for one data input cell which is linked to a dynamic range in the customer data worksheet. Now I have the problem...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.