Bob Phillips has just what you want with a workbook to download as well.

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

Read the page it is excellent. If there is any problem downloading the
workbook contact me



and I'll send you a copy.

Peter

"Khaledity" wrote:


I have managed to do the linkage with data validation, but I am still
stuck with combo boxes!!!