+ Reply to Thread
Results 1 to 2 of 2

Excel crashes when Combo Box loses focus

  1. #1
    ExcelEddie
    Guest

    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. #2
    ExcelEddie
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1