Results 1 to 2 of 2

Thread: Excel (vb6 dll) Formula Help & arguments description

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2015
    Posts
    11

    Unhappy Excel (vb6 dll) Formula Help & arguments description

    Hi.

    Im getting closer to finishing my Excell ADDin, BUT, i got stuck on a major problem!!!

    1 - How can i define some help for each argument of my formulas?
    2- How can i define the description of the formula on the "insert function" wizard?

    Ive tried several ways (XLA to passes parameters to the DLL, almost a winner, BUT an excel addin (XLA) calculates all UDFs on open... So... no go!)

    Can anyone help me?

    Thanks a lot
    Jorge

    P.S: Someone told me that this is only possible in Visual studio/ Xll addin.... C++ ( i couldn't believe it...)

  2. #2

    Thread Starter
    New Member
    Join Date
    Dec 2015
    Posts
    11

    Re: Excel (vb6 dll) Formula Help & arguments description

    Hi

    Figure it out (well, found the solution, thnaks to JPK)
    goto http://www.jkp-ads.com/Articles/RegisterUDF03.asp and download the exemple.

    Make ir an addin (xla)...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width