Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Loses Formatting | Excel Discussion (Misc queries) | |||
Excel loses linked workbook | New Users to Excel | |||
macro in chart loses focus | Charts and Charting in Excel | |||
COMBO BOX FOCUS | Excel Worksheet Functions | |||
Excel workspace loses formatting | Excel Discussion (Misc queries) |