I have a subroutine to dropdown the list portion of a ComboBox.
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( )
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?
Code:
Private Sub QuickShow()
'Display Quick Dropdown ListBox
cboQuick = cboQuick.DefaultValue
cboQuick.SetFocus
cboQuick.Dropdown
End Sub 'QuickShow
Code:
Private Sub cboQuick_Click()
. . .
Call QuickShow
End Sub 'cboQuick_Click
Any suggestions here?
Comment