The only change a UDF can make is to update the value in the cell(s) in
which it is entered.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I've got a worksheet with several thousand records and a user-defined
function that can take some time to calculate. Each of these records has
this function applied to it, so the calculation time will be substantial.
What I'm looking for is a way to have the function move the screen (or the
highlighter) to the current cell being evaluated. That way, as the entire
worksheet calculates, the user (me, actually) sees what cell is being worked
on.

Thanks for any help...