VBA macro executes when I press ESC?!

[andrew.ward]

Hi All,

I have an excel workbook created in 2007, but now running in 2010. In the workbook I have a form Combo box with a macro assigned to it. When I click any value in the combo dropdown list the macro executes. In 2007 I could click the combo dropdown box and then press ESC to exit from the form control without executing the assigned macro. Similarly I could also click on any other cell to exit from the control without executing the macro.

But, in 2010 if I press ESC or click on any other cell the macro will execute. How do I stop this from happening please? Sometimes I want to be able to exit from the combo box without executing the macro.

thanks for your help,
Andrew

 

[andrew.ward]

Anyone got any suggestions as to the cause or suggestions on where to start with debugging the problem?

Thanks
Andrew

 

[Michael M]

MAybe you should post your code !

 

[andrew.ward]

Thanks, but it isn't related to the actual code. I tested this by opening a new workbook in Excel 2010, adding a form combobox to worksheet 1 with a few dummy values to create a dropdown list and then assigned the following macro to it:

Sub Test_Code()
    
    ActiveCell.Value = Date 
    
End Sub

When I expand the dropdown list, then press ESC (or click on an empty cell) to exit from the combobox the macro still triggers. If I save and close this workbook then reopen in Excel 2007, then expand the dropdown list, when I press the ESC button (or click on an empty cell) I can exit out of the combobox without triggering the macro. Being able to exit out of the combobox without triggering the macro is obviously the desired behaviour.

Anyone got any thoughts why this is happening?

Thanks for the help
Andrew