Take a look at Debra Dalgleish's site:

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

Huyeote wrote:

Hi, all, I have a XL worksheet for user to enter data. In cell C11, I have a
validation rule to allow user to pick value from a list. I want to set up a
validation rule in cell D11 (wherever) and the available list of value to
choose depends on the value the user chose in cell C11. That means if user
choose 1 in cell C11, the validation rule in cell D11 will become a list of
"AA,BB,CC". And if user choose 2 in cell C11, the available list of value
will become "DD,EE,FF". Can anybody tell me how to do it? Do I need to write
a VBA script and how to?

Thanks in advance.

Huyeote

--

Dave Peterson