I had already removed the .Dropdown part like you suggested earlier for the 1st issue. It took care of the drop down appearing randomly. As for my 2nd query, the macros for combo box are still getting called at every step (checked in step by step execution using F8 key) in "Post MOC" macro, even...
Thanks for the advice. This definitely solves the issue of drop down appearing again and again despite making the sheet a little less user friendly.
It would be a great help if you could give some suggestions on the other two issues that I mentioned in my query. :-)
Hey Chichiro,
Thanks for replying. I am enclosing the sample file that contains all combo boxes and buttons that I am using for this file. If you could troubleshoot it, it will be a great help to me. :-)
Hello there!
Thanks for reading this.
I am using activex comboboxes for the first time in my worksheet and I am facing a couple of issues with the same. I have attached screen shots to better explain the issue.
1. I am using two combo boxes both having searchable dynamic lists. When I type...