Excel crashes when Combo Box loses focus

E

ExcelEddie

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...
 
E

ExcelEddie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top