Solved: ComboBox won't respond to repeat of previous selection

[xltrader100]

I'm using the Click Event of the ComboBox, but it acts like it's triggering on the Change Event. So if I select Item 1 on the drop down menu, then I can't select it again unless I first select away from Item 1 and then back to it. Is there any way to make it respond more like a real Click Event?

[Kenneth Hobs]

Maybe the Enter event would be a better fit.

[xltrader100]

Actually, I've tried just about every event available. I wonder why they bothered to provide both a Click and a Change event if they were going to make them both work like Change events.

[Kenneth Hobs]

The dropbuttonclick might be a bit better for you.

[xltrader100]

Nope. That was an early candidate, but no go.

[Kenneth Hobs]

You probably need to state your goals rather than solution routes that you want to pursue.

Most people care about the change event. Once changed, I am not sure why anything should happen if it is not changed.

[xltrader100]

My goal, as stated in the question, is to be able to select the same item twice in succession from a drop down menu in a ComboBox.

[Aussiebear]

What properties are selected in the combobox?

[xltrader100]

Private Sub ComboBox1_Click()
If ComboBox1.ListIndex = 1 Then Beep
End Sub

If I select Item2 then I get the beep, but it I select it again then I don't.

[Aussiebear]

No, I mean the properties of the combobox when you designed it.

[xltrader100]

I'm attaching a screen shot of the Properties Window for the ComboBox.

[mikerickson]

Perhaps this will work for you
Private Sub ComboBox1_DropButtonClick()
Static DropIsDown As Boolean
If DropIsDown Then
MsgBox "An item has been clicked"
Rem your routine
End If
DropIsDown = Not (DropIsDown)
End Sub

[xltrader100]

Thanks, Mike. That works great.

[xltrader100]

But, I don't really understand how it works. When Excel encounters the statement
Static DropIsDown As Boolean
doesn't this re-create the variable DropIsDown and initialize it as False? So how is the IF statement finding it to be True?

[mikerickson]

The first time it encounters a Static statement, it initializes the variable (as False in this case). Thereafter, the value of the variable doesnot change between runnings of the sub.