How to code an ALL option into a Combo Box
Posted
by Edmond
on Stack Overflow
See other posts from Stack Overflow
or by Edmond
Published on 2010-04-02T16:15:54Z
Indexed on
2010/04/02
16:23 UTC
Read the original article
Hit count: 281
vba
I have a combo box on my form with the choice of choosing organization 10, 20, 30.... I have added ALL to the combo list box, but am having trouble implementing an all statement in VBA. Below is the case statement I have to get info from organizations 10, 20, 30. How do I get ALL to generate??
Case Is = 1
If cboOrg.ListIndex < 0 Then
Call msg("Please select your organization!")
Exit Sub
End If
sQ = sQ & " CC LIKE '" & cboOrg.Value & "*'"
ORGCC = Trim(cboOrg.Value)
© Stack Overflow or respective owner