Help: Combobox to change according to another conbobox

[thunder_anger]

Hi all

i have this userform that have 12 places to enter data
two of them are comboboxes and need to be linked

the first combobox contains all values that i need and i put them in this code

Private Sub UserForm_Initialize()
CBX1.AddItem "Old"
CBX1.AddItem "Archive"
CBX1.AddItem "New"
End Sub

all what i want is
if CBX1 is "old"
cbx2 shall contain "1,2,3,4,5,6,7,8,9"
if CBX1 is "Archive"
cbx2 shall contain "101,102,103,104,105,106,107,108,109"
if CBX1 is "new"
cbx2 shall contain "1001,1002 etc"

is that possible

 

[thunder_anger]

UP

Is there any idea

 

[thunder_anger]

any ideas guys

 

[thunder_anger]

Found it
Never Mind Guys