Validation short cut to enter a different value from a drop

[rmtaylor]

When a range of cells is set to allow a validated list in a drop down is there a way of allowing the user to enter data other than that which appears on the drop down list without having to go into Data validation then clear all.

Thanks in advance

 

[PaddyD]

currently, the post 8 posts below this is:

http://mrexcel.com/board/viewtopic.php?topic=23098&forum=2&6

Paddy

 

[rmtaylor]

Thanks Paddy I got the info I needed

PS The total time from my posting to getting the info I needed into my sheet was under 10mins

 

[PaddyD]

10 minutes - we must be slipping