Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Loses Formatting ecellis Excel Discussion (Misc queries) 2 May 5th 09 02:32 PM
Excel loses linked workbook Mike New Users to Excel 3 April 6th 09 10:19 AM
macro in chart loses focus jackie Charts and Charting in Excel 11 November 8th 08 05:25 AM
COMBO BOX FOCUS -debi- Excel Worksheet Functions 0 July 18th 08 03:07 PM
Excel workspace loses formatting Snarf Excel Discussion (Misc queries) 3 March 16th 06 03:47 PM


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"