http://www.xldynamic.com/source/xld.Dropdowns.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"greg" wrote in message
oups.com...
Hi I would like to do the following in VBA .

1create 3 data validation lists
2make the second one dependent on first
3make the third one dependent on second

all 3 steps need to be done in VBA .
code samples will be greatly appreciated.