I have a subroutine to dropdown the list portion of a ComboBox.
- Private Sub QuickShow()
-
'Display Quick Dropdown ListBox
-
cboQuick = cboQuick.DefaultValue
-
cboQuick.SetFocus
-
cboQuick.Dropdown
-
End Sub 'QuickShow
It works from anywhere it is called from, either Event subroutines or from other functions and/or subroutines. Except from one event sub, cboQuick_Click()
- Private Sub cboQuick_Click()
-
. . .
-
Call QuickShow
-
End Sub 'cboQuick_Click
I can step through the code, and at the line End Sub 'cboQuick_Click the dropdown is removed, the list vanishes. It is there, and the downarrow will display it, but not automatically. I can put the line Call QuickShow as the last line of any other subroutine, and it works fine.
Any suggestions here?