I am hoping yo guys can help me with what I hope is an easy VBA question.
I have a sheet that is using combo boxes as part of a way to create an auto-fill searchable list in excel. That part I am fine with.
I have 3 combo boxes on 1 excel sheet that all do the same thing, here is the script...
Private Sub ComboBox1_Change()
Private Sub ComboBox2_Change()
Private Sub ComboBox3_Change()
I'm not experienced with VBA and I followed a guide to help me, the guide only had 1 combo box. When I added the other 2, I need the actions taken on any one combo box to not effect the other two.
Currently, when I click the drop down for one box it causes the other boxes drop down to activate. How can I separate the actions of each combo box?
Thanks in advance for your help!