Re: UDF Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I don't think so. Why would you want to know?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Koye Li" <koye.li@xxxxxxxxxxx> wrote in message
news:%23RM831WaGHA.4416@xxxxxxxxxxxxxxxxxxxxxxx
Let say we have defined an UDF fuction foo(a,b) that takes 2 cell
references
as its arguments :

public function foo(byval a, byval b)

and on the worksheet, we have

=foo(B1,C1)

Whenever B1 or C1 changes, foo() gets triggered and is called by Excel.
Is
there anyway within foo() to tell which argument originated the call?




.

Relevant Pages

  • Re: current date and time object
    ... >> (remove nothere from the email address if mailing direct) ... >>> Hi Bob, ... >>> Public Function fncWindowsTimerAs Boolean ...
    (microsoft.public.excel)
  • Re: formatting text
    ... >> (remove nothere from the email address if mailing direct) ... >>> Public Function formatString(str As String) ...
    (microsoft.public.excel.programming)
  • Re: formula problem
    ... HTH ... (remove nothere from the email address if mailing direct) ... > This formula has references to other sheets in the same file. ...
    (microsoft.public.excel.newusers)
  • Re: How to create a New system function
    ... Bob Phillips ... (remove nothere from email address if mailing direct) ... Public Function NewNumber ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Counting dates, within a list of dates
    ... references to those respective dates. ... Bob Phillips ... (remove nothere from email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)