I'm trying to create a conditional data validation for a cell ($D4) based on
the entry in cell ($B4). There are three possible entries for cell $B4.
I've created a named list for $B4 and based on the entry I want three
different conditional data validation types for cell $D4:

1. Allow a range of numbers (1 to 255)
2. Drop-down list A
3. Drop-down list B

I'm fairly proficient with Excel; however, I'm a very novice VBA programmer.

Do you have any suggestions on the above situation?

Rick