stanulavini
New Member
- Joined
- Dec 8, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hello, everybody. My first post here from a newbie learner on Excel.
I have a sheet where I am supposed to filter models of cars from 2 Combobox, one is for the manufacturer, another for the car models. I created a simple form Combobox and the data for that Combobox is coming from cell C in my sheets, the data in this cell C are from another sheet. I get that through a simple =(Models!D2). When I change the manufacturer, the models of the car change and that is working well.
The problem is that depending on the manufacturer of the cars that I choose from another combobox, the range of models change. So if I chose BMW for example, I have 3 cars, if I choose Volkswagen I have way more, and then there are some blank cells on my Combobox.
I tried many tutorials, but none of them worked for me.
Just to Resume:
I have a sheet where I am supposed to filter models of cars from 2 Combobox, one is for the manufacturer, another for the car models. I created a simple form Combobox and the data for that Combobox is coming from cell C in my sheets, the data in this cell C are from another sheet. I get that through a simple =(Models!D2). When I change the manufacturer, the models of the car change and that is working well.
The problem is that depending on the manufacturer of the cars that I choose from another combobox, the range of models change. So if I chose BMW for example, I have 3 cars, if I choose Volkswagen I have way more, and then there are some blank cells on my Combobox.
I tried many tutorials, but none of them worked for me.
Just to Resume:
- I have 2 sheets, one named "TIM" where are my Combobox, and one named "Models" where is the models of cars. TIM is getting data from Models.
- The combobox is getting the range data from Colum C, starting on cell 20. And I need to have a cell where the result of the combobox selection is shown.
