several comboboxes for one active cell

Hello,

I need help with the following issue:

I have a userform with a cascading combobox. The 1st cbo has 4 options, and according to the data inserted in the first cbo, it becomes visible one of four different cbo's.

My problem is that the differente cbo's should feed the same column in the "Base Dados" sheet.

Here is part of the code:

        ActiveCell.Offset(0, 7) = ComboBox5.Value
        ActiveCell.Offset(0, 7) = ComboBox4.Value
        ActiveCell.Offset(0, 7) = ComboBox6.Value
        ActiveCell.Offset(0, 7) = ComboBox7.Value

I run the userform ok but the data doesn't show in the "Base Dados" sheet.

I hope someone can help me.

The objective of creating several comboboxes is to avoid having 40 options in the second combobox and, based on the option selected in the first combobox, only the correspondent options populate the second combobox.

I don´t know how to do this using vba? is it even possible?

Ok romperstomper,

here is a sample of the book i'm using.
Hope you can help me. Thanks in advance.

Sorry,

In the User Form frmfrontoffice theres a combobox "cbointerlocutor" with 7 different options. Then i have 5 combobox "combobox 4, 5, 6, 7, 8" next to the label20 "tipificação" (this cbo's and label are invisible until something is selected in cbointerlocutor)

(It appears that theres only one combobox, but in fact, there's 5. All of them at the same height)

According to the data picked in the "cbointerlocutor", only the correspondent combobox appears.

This is working fine (i'm guessing)...

Then, when i click the commandbutton"cmdguardar" all the data goes to the "Base Dados" sheet. All of it except the column H, where should be the data from the second combobox.

I hope i was clear enough. Sorry the menus are in portuguese.

I've tryed it.

It's working great...Thank you very much