Data validation without data validation?

[Jaymond Flurrie]

I need to have a dropdown list to select values from and the list is populated from a named range. I understood that the way to do this is by using data validation. I just don't want the error system there at all, if user decides to input something stupid, let him. How do I implement this, what's the "override"-parameter of data validation?

edit. I think
.ShowInput = False
.ShowError = False

does the trick.

 

[xenou]

Hi,

Uncheck the box for "show error alert" (and/or "show input message"). Then just have a source range for the values to show.

Edit: nevermind ... you got it.
ξ