Testing combo box drop down list status

0

Is there an easy way to test, using VBA, if the drop down list of a combo box is visible?

Thanks,

Tony

Answer
Discuss

Answers

0
Debug.Print ComboBox1.Visible

The 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.

Discuss

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
tfurnivall May 10, '18 at 8:49 am
Did you get your problem solved?
Variatus (rep: 1413) May 10, '18 at 9:31 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login