W
William Benson
Hi, having a bit of a problem with this code which is designed to fill a
dropbox as it is being clicked. The reason I do this is that the values the
combo can be depend on other combo selections. Maybe my problem is not the
code but rather some property of the combo... however, I shouldn't think so.
I KNOW that the combo list fills, the problem is that the value the user
slects is not getting assigned to it.
I have the static variable telling me if I am on the way Up or Down (i.e.,
dropped or closing up) because I didn't want the code which resets the combo
to fire on the way up.
Private Sub cboHardness_DropButtonClick()
Static UpDown As Boolean
If UpDown Then
GoTo Exit_Me
End If
'Application.EnableEvents = False I tried disabling
events but no help
Call Fill_DropDown("cbo1")
'Application.EnableEvents = True
Exit_Me:
UpDown = Not (UpDown)
End Sub
dropbox as it is being clicked. The reason I do this is that the values the
combo can be depend on other combo selections. Maybe my problem is not the
code but rather some property of the combo... however, I shouldn't think so.
I KNOW that the combo list fills, the problem is that the value the user
slects is not getting assigned to it.
I have the static variable telling me if I am on the way Up or Down (i.e.,
dropped or closing up) because I didn't want the code which resets the combo
to fire on the way up.
Private Sub cboHardness_DropButtonClick()
Static UpDown As Boolean
If UpDown Then
GoTo Exit_Me
End If
'Application.EnableEvents = False I tried disabling
events but no help
Call Fill_DropDown("cbo1")
'Application.EnableEvents = True
Exit_Me:
UpDown = Not (UpDown)
End Sub