Look at these links on how to create dependent combo boxes

http://www.excel-easy.com/vba/exampl...mbo-boxes.html

http://www.davesexcel.com/dependentcombobox.htm