Select specific cells for data validation

[carlos1980]

Is there a way to select specific cells from a list that only show within a data validation set?

For example:
I have a list of fruits (Apple, Pears, Graph, Banana), but for this data validation I (the user) only want to show Apple and Graph so checkbox them so these are the only 2 fruits that appear in the drop down list.

Obviously the easiest option is to just delete the fruits I don’t want in the list but I want the list to stay the same, so it can be reused time and time again without having to reproduce the list.

[Adamsc21]

Try this. The formula hides items on the list based off which ones you checked. Let me know if this doesn't work for you.

[carlos1980]

Hi, I have tried the formula which works to hide them from the list, but it also hides them in column B. Is there a way to just hide them from the list but still display them in column B if checked?

[carlos1980]

Where is the formula as I don't seem to be able to locate it in the VBA or in any cells?

[carlos1980]

Found the formula now, couldn't see it to start with.