As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/

Excel VBA Help

ThundyrkatzThundyrkatz Registered User regular
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()
ComboBox1.DropDown
End Sub

Private Sub ComboBox2_Change()
ComboBox2.DropDown
End Sub

Private Sub ComboBox3_Change()
ComboBox3.DropDown
End Sub

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!

Posts

  • MrTLiciousMrTLicious Registered User regular
    I can't replicate this issue. Are you saying that just clicking one of the boxes results in all three boxes opening and displaying their options?
    If you can link the file (here or DM) I'd be willing to see what's going wrong.

    Elvenshae
  • ThundyrkatzThundyrkatz Registered User regular
    Hey Happy Monday! Thank you for replying MrTlicious. That is exactly what I am saying is happening. However, I found a different solution over the weekend and I think I am all set. Thanks again.

  • MrTLiciousMrTLicious Registered User regular
    No problem. Glad you got it fixed.

Sign In or Register to comment.