Excel Combo Box organizing question

[AlP]

Hello all,

I am using multiple COMBO BOXes on an excel sheet that relate to a data base on another worksheet. Is there a way to only show the information below on a senario like like?
Please help.

Example:

data#1
car
truck
motorcyle

data#2
doodge
ford
honda
chevy

data #3
red
blue
black
yellow
green
silver

data #4
100
200
300
400
500



COMBO BOX #1 = data #1
COMBO BOX #2 = data #2
COMBO BOX #3 = data #3
COMBO BOX #4 = data #4

If COMBO BOX #1 = Truck
COMBO BOX #2 = chevy,ford & dodge (only shows)
COMBO BOX #3 = red, yellow, green & silver (shows)
COMBO BOX #4 = 100, 300, 500 (shows)

If COMBO BOX #1 = motorcycle
COMBO BOX #2 = honda (only shows)
COMBO BOX #3 = blue black (shows)
COMBO BOX #4 = 300,400 & 500 (shows)


Thanks,
ALP

[HelpMe]

Try this

Private Sub UserForm_Initialize()

Sheets("Sheet1").Activate

With ComboBox1

.AddItem "car "
.AddItem "truck "
.AddItem "motorcyle"

End With


End Sub