several comboboxes for one active cell

[ncaravela]

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:

Please Login or Register  to view this content.

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

I hope someone can help me.

[romperstomper]

Why don't you just use two comboboxes and alter the data in the second one based on what you choose in the first? That way, you only have to populate the sheet from one combobox.

[ncaravela]

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?

[romperstomper]

You wouldn't have 40 options in the second combo - there wouldn't be any until you pick an option from the first one. A sample workbook would make this easier...

[ncaravela]

Ok romperstomper,

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

[romperstomper]

Care to give me a hint where I should be looking, and what is supposed to do what?

[ncaravela]

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.

[romperstomper]

Try this version.

[ncaravela]

I've tryed it.

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

[romperstomper]

Glad to help. Please don't forget to mark the thread Solved.