Hello,

I have 2 combobox - 1st for years and 2nd for half-years (H1-09, H2-09, H1-10, H2-10 and so on..)
I have populate the 1st combobox (YPeriod) with the unique years with this (part of my macro-code):

For Each YCell In Y_rng
If Not YPeriod.Exists(YCell.Value) Then _
YPeriod.Add Key:=YCell.Value, Item:=0
Next

This gets me: 2009, 2010, 2011, 2012 and so on...

how can I populate my 2nd combobox (HPeriod) based on the keys of the YPeriod combobox?
for 2009 in YPeriod: add keys "H1-09" and "H2-09" in HPeriod
for 2010 in YPeriod: add keys "H1-10" and "H2-10" in HPeriod

thank you