Data validation

[mlk]

Is there a way to narrow down data value selections for users based on input criteria?

What I would like to do is have users select a value from column A, but then in column B I want to narrow down their value list selection BASED on the value they selected in column A.

For example, if users selected "Night" in column A, then I want "Bat", "Owl", "Kinkajou" to be the only available values in column B for users to select from. However, if they selected "Day" in Column A, then I want "Dog", "Cat", "Horse" to be the only available values in Column B for users to select from.

The goal is to narrow their selections down (based on their earlier value selections) in order to avoid data entry mistakes

[VBA Noob]

Does this link help

http://www.contextures.com/xlDataVal02.html

VBA Noob