Clear Combobox without firing change event

[sharky12345]

I have a ComboBox on a Userform which has MatchRequired set to TRUE.

I want to be able to clear it without firing the change event for the Combobox if someone can help please?

 

[Domenic]

First, declare a boolean variable at the module level. Then use it to exit the change event when clearing/removing the value from the combobox. Maybe something like this...

[FONT=Courier New][COLOR=darkblue]Option[/COLOR] [COLOR=darkblue]Explicit[/COLOR]

[COLOR=darkblue]Dim[/COLOR] m_bLocked [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]Boolean[/COLOR]


[COLOR=darkblue]Private[/COLOR] [COLOR=darkblue]Sub[/COLOR] ComboBox1_Change()
    [COLOR=darkblue]If[/COLOR] m_bLocked [COLOR=darkblue]Then[/COLOR] [COLOR=darkblue]Exit[/COLOR] [COLOR=darkblue]Sub[/COLOR]
    [COLOR=green]'Your code for the change event[/COLOR]
    [COLOR=green]'[/COLOR]
    '
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]


[COLOR=darkblue]Private[/COLOR] [COLOR=darkblue]Sub[/COLOR] CommandButton1_Click()
    m_bLocked = [COLOR=darkblue]True[/COLOR]
    Me.ComboBox1.Value = ""
    m_bLocked = [COLOR=darkblue]False[/COLOR]
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR][/FONT]

Hope this helps!

 

[sharky12345]

Perfect - thanks!