Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining whether function called by Excel or VBA
Another one I cannot seem to figure out..
I'm trying to determine within a function whether it has been called directly from Excel or from another VBA sub/function. I've tried looking for ways to access the call stack, but have had no luck. Does anybody have any clues on this one? Thanks in advance, Ryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining whether function called by Excel or VBA
Tried that one too. Unfortunately, it returns information
about where VBA was ultimately called from and, since all my functions are ultimately called from Excel, that doesn't work. That is, unless there's more to the Caller property than I'm seeing. Any other ideas? -----Original Message----- Checkout the Caller property. Alan Beban Ryan Poth wrote: Another one I cannot seem to figure out.. I'm trying to determine within a function whether it has been called directly from Excel or from another VBA sub/function. I've tried looking for ways to access the call stack, but have had no luck. Does anybody have any clues on this one? Thanks in advance, Ryan . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining whether function called by Excel or VBA
I guess I don't know what you mean by "called directly from Excel or
from another VBA sub/function." Perhaps you could provide a brief illustration of each, and what you are trying to learn. Alan Beban Ryan Poth wrote: Tried that one too. Unfortunately, it returns information about where VBA was ultimately called from and, since all my functions are ultimately called from Excel, that doesn't work. That is, unless there's more to the Caller property than I'm seeing. Any other ideas? -----Original Message----- Checkout the Caller property. Alan Beban Ryan Poth wrote: Another one I cannot seem to figure out.. I'm trying to determine within a function whether it has been called directly from Excel or from another VBA sub/function. I've tried looking for ways to access the call stack, but have had no luck. Does anybody have any clues on this one? Thanks in advance, Ryan . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining whether function called by Excel or VBA
Called from a cell (worksheet function)??
If TypeOf Application.Caller Is Range Then 'it's from a UDF in a cell Else 'it's not from a UDF in a cell End If Ryan Poth wrote: Tried that one too. Unfortunately, it returns information about where VBA was ultimately called from and, since all my functions are ultimately called from Excel, that doesn't work. That is, unless there's more to the Caller property than I'm seeing. Any other ideas? -----Original Message----- Checkout the Caller property. Alan Beban Ryan Poth wrote: Another one I cannot seem to figure out.. I'm trying to determine within a function whether it has been called directly from Excel or from another VBA sub/function. I've tried looking for ways to access the call stack, but have had no luck. Does anybody have any clues on this one? Thanks in advance, Ryan . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I know which cell a function is called from? | Excel Worksheet Functions | |||
What is this function called?? | Excel Discussion (Misc queries) | |||
Function, dont know what its called | Excel Worksheet Functions | |||
Idea for an Excel function called "Spread" | Excel Worksheet Functions | |||
mystery function called 'TABLE' | Excel Worksheet Functions |