Unselect current combo box macro

[satheo]

I have a sheet with quite a few activeX combo boxes that users select stuff from, then an export macro bound to a hotkey. The issue is that if you try to use the export macro while you still have a combo box selected it doesn't run and puts some strange characters in the box over what was in there before. Yeah users can just click somewhere else and run it but I'd like to make it as fool-proof as possible.

I don't know much about VBA, the export macro is a module, do I need to put some sort of call to it in the workbook objects or something?

 

[Gokhan Aycan]

Others may have a much better solution. Just as an idea:

Private Sub ComboBox1_KeyUp(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

    'Debug.Print Shift, KeyCode
    
    If Shift = 3 And KeyCode = Asc("K") Then
        Debug.Print "ok"
        Call Module1.test_Combobox
    End If

End Sub

Where macro is bound to shortcut CTRL + SHIFT + K.

Shift Values: SHIFT (1), CTRL (2), ALT (4)