Take a look he

http://www.dicks-blog.com/excel/2004...le_functi.html

--
Regards

Juan Pablo González

"Chris" wrote in message
...
I'm working with Excel XP.

I have created a VBA function which calculate a value
depending on specific cells.
In my worksheet I'm calling this function from a cell.

This cell contains : "=UpdateCell()"

This works fine.
My cell is not refreshed automatically, so I'm looking
for a way to have this cell updated automatically when
the depending cells are changing.