Is it possible to create a drop-down list with a custom, typeable response option?

[RedMisterExcel]

Hey everyone, how are you all doing? This is my first time here, so please be gentle.

No, but seriously, I need help. I want to know if it's possible to create a drop-down list that provides an option for someone to click and begin to type a custom response in the space. Thanks guys!

 

[Akuini]

@RedMisterExcel, welcome to the Forum.
Could you explain what you're trying to do in more detail?

 

[RedMisterExcel]

@RedMisterExcel, welcome to the Forum.
Could you explain what you're trying to do in more detail?

Hey man, so you know how you can use data validation to create a drop-down list with specific options? Well, I want one of those options to be a field that allows you to type a custom response in the field where the other drop down list items would appear.

 

[Akuini]

Could you give an example?

to type a custom response in the field where ..

what do you mean by field?

..the other drop down list items would appear

this drop down is in another cell?

 

[RedMisterExcel]

Could you give an example?

what do you mean by field?


this drop down is in another cell?

So, see how this data validation list creates a drop-down menu allowing me to pick from one of the entries? I want one of those entries to be something like "enter custom response" or "other", and when the user clicks that, it allows them to type text in the field where the entry would have appeared normally (i.e., where the word "green" is right now). Does that help?

 

[Akuini]

Let's say you pick "other", then you want to type anything in the cell without any restriction? or you want a different data validation list to appear?

 

[RedMisterExcel]

Let's say you pick "other", then you want to type anything in the cell without any restriction? or you want a different data validation list to appear?

Type anything in the cell without any restriction. Like a custom response.

 

[Akuini]

You can set this:
On Data Validation: on the Error Alert tab, remove the check mark to the "Show error alert after invalid data is entered box".

so the data validation still shows "green,red,orange ..etc" which you can pick but you can also type anything in the cell.

 

[RedMisterExcel]

You can set this:
On Data Validation: on the Error Alert tab, remove the check mark to the "Show error alert after invalid data is entered box".

so the data validation still shows "green,red,orange ..etc" which you can pick but you can also type anything in the cell.

Copy, that works, but is there no way to put a preset response that says something like "other" which THEN leads to the person being able to type in a response?

 

[Akuini]

but is there no way to put a preset response that says something like "other" which THEN leads to the person being able to type in a response?

It requires vba. Are you open to using VBA?