Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Function not being auto calculated when cells change..help?
I created a custom function (See below)
Which takes validated input from 7 other cells parses using MID and concantenates and returns the result into an 8th cell. WHen I change the contents of any of the cells the value is not updated in the 8th cell...Even if I press F9 it wont update it. I have to place the cursor in the 8th cell and press enter once to get the updated value. Is there a way to correct this behavior? In my options I have auto calculate turned on. |
#2
|
|||
|
|||
Hi Alex
the discussion at http://tinyurl.com/42q34 especially Dick Kusleika's comments might interest you Cheers JulieD "Alex Wolff" wrote in message ... I created a custom function (See below) Which takes validated input from 7 other cells parses using MID and concantenates and returns the result into an 8th cell. WHen I change the contents of any of the cells the value is not updated in the 8th cell...Even if I press F9 it wont update it. I have to place the cursor in the 8th cell and press enter once to get the updated value. Is there a way to correct this behavior? In my options I have auto calculate turned on. |
#4
|
|||
|
|||
Use application.volatile in your code. See
http://www.sulprobil.com/html/uniqrandint.html for example. HTH, Bernd |
#5
|
|||
|
|||
You didn't show your code, but it's usually best to pass the ranges to the
function. That way excel knows when you change one of those cells, it's time to recalculate your UDF. Alex Wolff wrote: I created a custom function (See below) Which takes validated input from 7 other cells parses using MID and concantenates and returns the result into an 8th cell. WHen I change the contents of any of the cells the value is not updated in the 8th cell...Even if I press F9 it wont update it. I have to place the cursor in the 8th cell and press enter once to get the updated value. Is there a way to correct this behavior? In my options I have auto calculate turned on. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you enable auto complete from a custom list in Excel? | Excel Discussion (Misc queries) | |||
troubleshoot custom Excel Auto Filters when the column is a # or d | Excel Worksheet Functions | |||
how do i set an auto date function in excel or word? | Excel Discussion (Misc queries) | |||
Auto sum Function | Excel Worksheet Functions | |||
Is there a way to have a function auto correct words in ALL CAPS . | Excel Worksheet Functions |