Make sure that the C cell has the value Hello in it, then add this formula
to the DV type of List

=IF(C1="Hello",rng)

where rng is the range of your list

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Walt Herman" wrote in message
...
Hi! I am trying to enforce selection from a list (Range1) in column D when
the value in column c is equal to "Hello", if the value in column c does
not
equal "Hello" I want the user to be able to type in whatever they want in
column D. I have pored through the newsgroup and not found anything
relevant,
hence this question...Thanks...