I know that there is VBA code that will drop down a combo box - cboField.dropdown.
Is there a way to do the reverse action? For example, if the combo box has been clicked, the list of contents of that dropdown will be displayed. I then have a message box that comes up when an item in that drop down is selected. I would like to close the drop down if possible.
I know that this question will probably baffle people as to why I need this, but it is much harder to explain why.