need vba to datavalidation throgh combobox1-5,

Dear Expert

I want gets data list up through 6 combobox.. I want get values from sheet (DV)

Depends upon value of column A:A Indirect B:B ,
Select the B:B value Indirect C:C,
Select the C:C Value Indirect D:D
Select of D:D Value Indirect E:E....

If Idea Select In Combobox-1 Then List Up Center & Pad
If Center Select In Combobox-2 Then List Up If C340 Select In Combobox-3 List 7 Topbill In Combox 4
If 52-3118702 Select In Combobox-4 Then List Up If Win8 64Bit Em En Select In Combobox-5


find the attachment you may get understand easily

any experts help on this?

i created one form with 5 comboboxes, from list of one column i want derivate another value...

dude Its really works... but actual requirement is updates give in userform and will save data in excel mean while sheet is protected.. if you help with vba code really helpful ..

Perfect Dude !!! One and only requirement i have one combo and 5 textbox added I want save data in E.G sheet whenever select all combobox and enter data into text then i click button savedata into sheet E.G sheet find the attachment.........please dude this only last requirement from mine.
first thanks for spend your value time for me....

Dude Perfect!!! Thanks Alot and for your patience ........Everstrivinb Ever ever Master of Macro... Thanks once again