I need help linking ComboBoxes. Basically if I have a CombBox in
Worksheet for Divisions, and another one for programs within eac
division. I want to know how to populate the Programs box depending o
what the user selects in the Divisions box.

Unfortunately, I can't use User Forms, so I would need a solution tha
would work within the Worksheet itself.

Thanks

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

Mail me direct (bob . phillips @ tiscali . co . uk - remove the spaces) for
a simple to adopt ande adapt workbook that shows this tedchnique.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"cmk18 " wrote in message
...
I need help linking ComboBoxes. Basically if I have a CombBox in a
Worksheet for Divisions, and another one for programs within each
division. I want to know how to populate the Programs box depending on
what the user selects in the Divisions box.

Unfortunately, I can't use User Forms, so I would need a solution that
would work within the Worksheet itself.

Thanks!


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