Microsoft KB Archive/213243

= Odd refresh behavior after you specify a conditional format in Excel =

Article ID: 213243

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213243





For a Microsoft Excel 97 for Windows and a Microsoft Excel 98 Macintosh Edition version of this article, see 156892.



SYMPTOMS
When you specify a conditional format that refers to a user-defined function in Microsoft Excel, you may experience the following symptoms:
 * The screen stops updating.
 * The screen redraws incorrectly.
 * The message box reappears continuously after clicking OK.
 * Selected cells blink.
 * Excel stops responding (hangs).



CAUSE
This problem may occur when the following conditions are true:
 * You created a user-defined function that displays a message box.
 * You specified a conditional format that refers to the user-defined function you created.



WORKAROUND
To have your screen refresh correctly, save and close the workbook. If the screen does not update correctly after closing the workbook, follow these steps:
 * 1) Exit Excel.
 * 2) Open the workbook.
 * 3) Remove the conditional formatting that refers to the user-defined function.
 * 4) Save the workbook.

Note In some cases, this problem may be resolved when you remove the message box from the function.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.



MORE INFORMATION
For more information about how to get help with Visual Basic for Applications, click the following article number to view the article in the Microsoft Knowledge Base:

226118 List of resources that are available to help you learn Visual Basic for Applications programming

Additional query words: hang hangs lock crash crashes freeze freezes XL2002 XL2000 XL2003 XL2007

Keywords: kbdtacode kbenv kbfaq kbpending kbprb kbprogramming KB213243

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.