ComboBox DropDown List Not Working Correctly

Help Anyone!

I currently have the code below but when I write in ComboBox2 on the worksheet the dropdown list appears under the first ComboBox1 if something is already written in on ComboBox1. How could I have the appropriate dropdown list appear under ComboBox2, ComboBox3, and ComboBox4? The section I am talking about on the attached form is the category code field..



Private Sub ComboBox1_Change()

ComboBox1.ListFillRange = "Price_Category"
ComboBox1.DropDown


End Sub



Private Sub ComboBox2_Change()

ComboBox2.ListFillRange = "Price_Category2"
ComboBox2.DropDown


End Sub

Private Sub ComboBox3_Change()

ComboBox3.ListFillRange = "Price_Category3"
ComboBox3.DropDown


End Sub

Private Sub ComboBox4_Change()

ComboBox4.ListFillRange = "Price_Category4"
ComboBox4.DropDown


End Sub






Example when i input something in ComboBox 1 I would get a dropdown list of choices based on what I inputted. After I pick my selection from my dropdown list from ComboBox 1 and try to go to ComboBox 2, the dropdown list appears under ComboBox 2 again. I want the dropdown list to work for ComboBox 2 independently

Please see picture 1 and picture 2 you on attachment you will understand what is happening.
Picture 1 - you see the dropdown list working correctly under combobox 1.
Picture 2 - dropdown list appear under combobox 1, but it should appear under ComboBox 2.

Picture 1
Picture 1.jpg


Picture 2
Picture 2.jpg

Example when i input something in ComboBox 1 I would get a dropdown list of choices based on what I inputted. After I pick my selection from my dropdown list from ComboBox 1 and try to go to ComboBox 2, the dropdown list appears under ComboBox 2 again. I want the dropdown list to work for ComboBox 2 independently

Please see picture 1 and picture 2 you on attachment you will understand what is happening.
Picture 1 - you see the dropdown list working correctly under combobox 1.
Picture 2 - dropdown list appear under combobox 1, but it should appear under ComboBox 2.

Picture 1
Picture 1.jpg


Picture 2
Picture 2.jpg