No change event on control toolbox combo box when selection is the same?

[Don Wiss]

Of the three combo boxes available I generally prefer the simple Data
Validation drop down list. But in this particular use I want the same combo
box to be mirrored on two sheets. Trying to get Data Validation ones to
stay in sync with change events gets ugly.

So for this input we had been using a Forms combo box. They work very
nicely, but one can't set their background color, and we like to use yellow
for input fields.

This gets me to using the one in the control toolbox. I'd like it to work
as close to a Forms one as possible. So after the user has made a selection
I want to put the focus back on the sheet. People have come up with various
ways to do this. The one I've been using is

Private Sub ComboBox1_Change()
SendKeys "{ESC}"
End Sub

But in the combo box I'm working with now, if the user leaves the selection
the same it doesn't fire this macro and the focus remains on the control. I
have Style=DropDownList. MatchRequired=True. MatchEntry=Complete.
AutoWordSelect=True. EnterFieldBehavior=SelectAll.

Is there any way to get the behavior I want?

Don <donwiss at panix.com>.