Moving in the worksheet during an evaluating function
 

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...

Moving in the worksheet during an evaluating function
 

So that means that any code in the UDF that affects highlighter movement or
adjusting the screen won't be performed?

"Tushar Mehta" wrote in message
om...
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...

Moving in the worksheet during an evaluating function
 

Why not try it and check? I cannot make XL2003 scroll with code in a
UDF.

--
Regards,

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

In article ,
says...
So that means that any code in the UDF that affects highlighter movement or
adjusting the screen won't be performed?

"Tushar Mehta" wrote in message
om...
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...

Moving in the worksheet during an evaluating function
 

I did try it before posting the initial question, and I had the same result
as you did. I was just wondering if I wasn't programming it correctly, but I
guess I was. Thanks for the input. Much appreciated!

"Tushar Mehta" wrote in message
om...
Why not try it and check? I cannot make XL2003 scroll with code in a
UDF.

--
Regards,

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

In article ,
says...
So that means that any code in the UDF that affects highlighter movement
or
adjusting the screen won't be performed?

"Tushar Mehta" wrote in
message
om...
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...