ListIndex property
I created a RESET button my command bar that looks at a command bar controls tab property & based on that sets the combo controls list index to zero.
Public Function genericCase(intCase As Integer)
Select Case intCase
'resets every combo box in "Filter Toolbar" except YEAR & TYPE...
Case 2
For Each ctl In CommandBars("Filter Toolbar").Controls
Select Case ctl.tag
Case 3, 4, 5
ctl.ListIndex = 0
End Select
Next ctl
End Select
End Function
But now it seems that whenever I choose something from the combo box, it reverts back to index 0. I created the reset button b/c without it, I couldn’t leave the combo with an empty string. Now, with this facility to do so, I can’t get the combo control to be anything BUT an index of zero! Any advice would be appreciated.
I created a RESET button my command bar that looks at a command bar controls tab property & based on that sets the combo controls list index to zero.
Public Function genericCase(intCase As Integer)
Select Case intCase
'resets every combo box in "Filter Toolbar" except YEAR & TYPE...
Case 2
For Each ctl In CommandBars("Filter Toolbar").Controls
Select Case ctl.tag
Case 3, 4, 5
ctl.ListIndex = 0
End Select
Next ctl
End Select
End Function
But now it seems that whenever I choose something from the combo box, it reverts back to index 0. I created the reset button b/c without it, I couldn’t leave the combo with an empty string. Now, with this facility to do so, I can’t get the combo control to be anything BUT an index of zero! Any advice would be appreciated.
Code:
