Drop down list - allow ability to enter something not on list

[OM2]

I've only just discovered being bale to create list in cells - helping the user choose their input

This is great. Except, is it possible to allow the user to input something else NOT on the list?
I've tried and it doesn't seem possible

Any helps would be great

Thanks


OM

[TMS]

Untick "Show error alert after invalid data is entered" on the Error Alart tab.

Seems a little pointless having Data Validation on and not enforcing it though.


Regards, TMS

[JO505]

In the DV setup window, open the tab for Error Alert and unclick the box to show error alert after invalid message entered.

Jim O

[OM2]

guys: THANKS!
just what i needed
i wanted to allow the user have a selection from a drop down list - ok 90% of the time
but then, 10% of the time, not possible to predict that is required for input would be required

[TMS]

I understand the requirement. However, if you intend/need to analyse the data, then random data input is often not very helpful.

Whatever, you can do what you need to do


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[popipipo]

In this file you can expand the validation list

[TMS]

@popipipo: neat. I'd be inclined to use INDEX rather than OFFSET for the Dynamic Named Range. OFFSET is volatile, whereas INDEX is not.

Please Login or Register  to view this content.

Regards, TMS

[popipipo]

I did not make this file.
Usually I also use the index methode.