ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel crashes when Combo Box loses focus (https://www.excelbanter.com/excel-programming/361741-excel-crashes-when-combo-box-loses-focus.html)

ExcelEddie

Excel crashes when Combo Box loses focus
 
Hope someone can help with this problem...

I have an Excel worksheet that is using a few combo boxes.
If you pick a value from any of the combo boxes and then move
the focus to another cell or combo box using the mouse, life is good.

But if you dare use the TAB or ENTER keys to move the focus,
Excel crashes.

Has anyone encountered this problem? It happens whether the sheet
is protected or not. It happens is Excel 2003, XP, or 2000 (in 97, the
focus
just seems to get lost, but I don't care as I do not need it to work in
97).
It happens whether the AutoTab property is set to True or False.

I am stumped...


ExcelEddie

Excel crashes when Combo Box loses focus
 
I should have added that these combo boxes have a
KeyDown event that moves the focus to the next control
or cell.

It seems to be the line "cboControlName.Activate" that
causes the crash.



All times are GMT +1. The time now is 06:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com