J
Jason Rodman
I have a custom VBA function that I use in my spreadsheet. The problem is
that when it is called using the function editor, every keystroke causes it
to recalculate the function. Now, the function can sometimes take a long time
to return because it is calling a database, causing the editor to lock up on
every key stroke making it impossible to use the editor.
A- is there a way to make it not calculate on each key press.
-- or --
B- is there a way to determine if the function editor is calling the
function so I can return dummy data until its called from an actual cell?
that when it is called using the function editor, every keystroke causes it
to recalculate the function. Now, the function can sometimes take a long time
to return because it is calling a database, causing the editor to lock up on
every key stroke making it impossible to use the editor.
A- is there a way to make it not calculate on each key press.
-- or --
B- is there a way to determine if the function editor is calling the
function so I can return dummy data until its called from an actual cell?