Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Conditional formatting formula is evaluated repeatedly

Hello

I want to use a vba function in a formula for conditional formatting and
found that this formula is evaluated repeatedly under certain circumstances.
For a simple test I used

Function vbaFormat(ByRef rng as Range) as Boolean
vbaFormat = True
Debug.Print CStr(Now)
End Function

and as the format formula:
=NOT(vbaFormat(D16:D20)) ' make font color red

The cell where the format is applied is not part of the range that is passed
to vbaFormat.
When I select this cell and then do nothing the vbaFormat is called about 2
times per second. This also depends on the position of the mouse cursor. The
cell and the range for the function do not contain any data.
Does anyone know why this function is called repeatedly though there is no
user interaction and no macros are running in the background?
I use Excel 2003

Thanks


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
Using an If Formula with Conditional Formatting Cali Excel Discussion (Misc queries) 1 January 21st 10 07:46 PM
CONCATENATE text to create a formula to be evaluated Brian Excel Worksheet Functions 2 January 2nd 10 02:25 AM
how do I repeatedly substitute a value in a formula rob_t Excel Worksheet Functions 4 December 18th 07 03:46 AM
Formula not evaluated automaticly in Office 2003 Hz-man Excel Worksheet Functions 2 January 30th 06 11:39 PM
conditional formatting with FORMULA... Please HELP! Chris M Excel Discussion (Misc queries) 1 August 20th 05 12:28 AM


All times are GMT +1. The time now is 08:31 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"