Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Odd refresh behavior after you specify a conditional format in Excel


View products that this article applies to.

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

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Status

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

↑ Back to the top


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

↑ Back to the top


Keywords: KB213243, kbprogramming, kbprb, kbpending, kbfaq, kbenv, kbdtacode

↑ Back to the top

Article Info
Article ID : 213243
Revision : 5
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 361