Combobox coding

[goncalo]

Hello everyone,i am new in vba and i would really appreciate some help when it comes to comboboxes.
i've been able to code multiple comboboxes into the sheet but i want some of them to only be active after the user has selected items in the first 2 comboboxes
what im trying to say is that i want combobox3 only to become available to be selected AFTER i've selected items in combobox1 and in combobox2 .
I've been trying to achieve this for hours but no luck,does anyone know how i can go around and try to achieve this?
Any kind of help would be appreciated,thank you

 

[jdraw]

Research Cascading comboboxes

 

[Gasman]

You mention 'sheet'
Are we talking Excel here?

 

[theDBguy]

Hi. Welcome to AWF!

I am also wondering if you're referring to using comboboxes in Excel or Access.

 

[MajP]

If this is Access and a Continuous form this can be very challenging. Far easier in single form view.

 

[goncalo]

my bad,i should've mentioned i was talking about excel haha

 

[Gasman]

Well I would expect the logic to be the same as per Access?

However, my first point of call is always a search, as someone else must have wanted to do the same?

Google Search

 

[CJ_London]

In access youcan handle your requirement but according to this link, not possible in excel, but suggests an alternative

Disable or hide options in combo box VBA Excel

I have a combo box in a Excel Userform that consist of User Group Types. Depending on the user access level, I would like to have some Option\item disable or not visible. I don't want to use Remove...

stackoverflow.com

edit: maybe you can create the 3rd combo dynamically when required

Programmatically add ComboBox in VBA (Excel)

I am trying to create, place and fill in elements of a ComboBox in VBA. I don't understand what I am missing, but I cannot possibly figure out how to do it. I do not have MSForms in my API (i.e. I ...

stackoverflow.com

 

[Pat Hartman]

@goncalo Welcome. This is a mostly Access forum although we have a lot of people who can also answer Excel questions. To avoid confusion, please ask Excel questions in the Excel section.