You may want to take a gander at Debra Dalgleish's Create Dependent Lists:

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

--

Kashgarinn wrote in message ...
Bob:

I'd like to run a macro dependant on what I choose, so the control tool
combobox would be great, thanks.

my e-mail:

K.


---
Message posted from http://www.ExcelForum.com/