Teams...............BX#1.....BX#2...etc....etc.... .etc
BX#1...................AA.......AW
BX#2...................CB.......CR
BX#3...................GB.......ET
BX Sites...............HC.......JV
BX 149.................JH.......MP
MH#1...................LJ.......NG
MH#2...................LR......TS
MH Sites...............MP.....TP

I need help making 2 comboboxes work together in an "userform". I don't
even know how to start with the VBA code. I can populate the 1st
combobox with the team list... but I need that when the user selects a
team, that the corresponding information is populated in the 2nd
combobox.

For example, if the user selects "BX#1", then the BX#1 list is
populated in the 2nd combobox. If user selects "MH Sites" then the MH
Sites list is populated and so on.

There are 24 different list depending on 1st selection.

Please experts, help me!

- Larry -
VBA Amateur


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