If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom function
I have written a custom Excel function in VBA which retrieves data from a
remote server. This function can take up to several seconds to run, depending on a variety of factors. I have encountered some problematic behavior in the process of inserting the function in cells at the point where the function arguments are entered. Due to the slow response of the function, I can observe that after the last argument is entered, the function runs once to fill the results field in the lower-right corner of the Function Arguments dialog box, then a second time to fill the formula result field in the lower-left corner. Clicking OK after both fields have calculated closes the dialog normally and the function appears to run a third time to place the result in the target cell. The problem arises when OK is clicked before both fields have finished calculating. In this case, Excel appears to start queuing calls to the function in a loop until eventually it freezes or aborts. I have been able to duplicate the behavior by creating a test function which employs a timer to imitate the response time, so I know that the issue is with the Insert Function process and not my function. -- Christina L. -- Christina L. |
#2
|
|||
|
|||
Custom function
You should post your code with the google group
microsoft.public.excel.programming. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Function not updating | lister_d_000169 | Worksheet Functions | 2 | March 30th, 2006 10:03 AM |
determine if Excel is open | geebee | General Discussion | 11 | January 20th, 2006 09:25 PM |
Custom function returning VALUE error | alex.k | General Discussion | 6 | September 27th, 2005 03:05 AM |
VBA Custom function for lookup | Sami82 | Worksheet Functions | 9 | September 12th, 2005 03:20 PM |
Custom Function in a Select Query | Kirk P. | Running & Setting Up Queries | 5 | January 4th, 2005 09:27 PM |