Debra Dalgleish shows how you can set up dependent data validation
he

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

Hope this helps.

Pete

On Sep 15, 2:15*pm, Dennis Cheung
wrote:
in cell A2, user can select only A and B, i know how to do this.
if A is selected in cell A2, i need only aa, ab, ac can be seclect in cell A3,
if B is selected in cell A2, i need only ba, bb, bc can be seclect in cell A3.

can someone tell me how can do this?
--
Dennis Cheung