If you have a dynamic range in the workbook, whose size relates to the
value of the first combobox
e.g. on Sheet1
column A|column B
A Ai
A Aii
A Aiii
B Bi
B Bii
C Ci
C Cii
C Ciii
etc whatever...

and C1 is linked to CombBox1.ControlSource
with a named range "MyRange"
=OFFSET(Sheet1!$B$1,MATCH(Sheet1!$C$1,Sheet1!$A:$A ,0)-1,0,COUNTIF(Sheet1!$A:$A,Sheet1!$C$1),1)

Then put something like this in the the _enter event of ComboBox2 or
_exit event of ComboBox1

ComboBox2.Clear
if thisworkbook.sheets("Sheet1").range("C1").value<e mpty then
for each c in thisworkbook.sheets("Sheet1").range("MyRange")
ComboBox2.additem (c.value)
next


You'll probably need to tweak it a little...
Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=548596