Is there an easy way to test, using VBA, if the drop down list of a combo box is visible?
Thanks,
Tony
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Testing combo box drop down list status
0
Answers
0
Debug.Print ComboBox1.VisibleThe above code will print True or False to VBE's Immediate window. However, I suspect that you are interested in knowing whether or not the drop-down list is extended. Perhaps this thread will help. For a better answer I suggest you let us know why you want to know and what you intend to do with that knowledge.
Discussion
You';re right - I should have been more precise in my question. I want to test if the DropDown list has, indeed, been dropped down. Thanks for the pointer to the other thread.
Tony
Tony
tfurnivall May 10, '18 at 8:49 am
Did you get your problem solved?
Variatus (rep: 4889) May 10, '18 at 9:31 pm