View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dch3 dch3 is offline
external usenet poster
 
Posts: 15
Default Refresh/Recalculate a Custom Function

How do I set things up so that a custom function automatically recalculates
when a cell value changes? I have function which calculates a value based on
several cells and need the value updated when the cells change.

In the example below, I need the value in cell A1 to update when the value
of B1, C1 or D1 changes.

Column
Row A B C D
=getDescription() Y N Y

getDescription looks at the values in the cells and returns a string based
on the values found. Should I be passing the values directly into the
function as in

=getDescription(B1, C1, D1)

David H