| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect when a UDF is being edited in the Function Wizard
Does anyone know how to detect when a UDF is being edited in the
Function Wizard? I need to know because my function takes a long time to calculate, so I want to switch off calculation attempts until data entry is complete. My idea is that if I know the Function Wizard is active then I can just skip the calculation. I have already tried looking at Application.Caller but this seems to return a range whether in the Function Wizard or not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use function edited in VBA in excel sheet | Excel Discussion (Misc queries) | |||
| Can I use a function to detect whether a cell is highlighted? | Excel Worksheet Functions | |||
| Excel 2003: can I insert a "last edited" date function? | Excel Worksheet Functions | |||
| "Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
| Is there a function to detect changes in any given cell? | Excel Worksheet Functions | |||
Threaded Mode
