Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    UDF argument help! (Excel 2000 >)

    I got this code from a previous post in the Excel lounge, and am trying to get it to work as I'm playing around to see if I can get a user defined function to contain argument descriptions. I am having no luck though! Can someone assist me in getting these two simple functions to work, (displaying the argument help in the function wizard!)!

    POWER PROGRAMMING TECHNIQUES

    Created by Laurent Longre

    This example shows how to register functions into user-defined catagories and provide descriptions for their arguments. The Auto_Open procedure registers the two functions, Multiply and Divide in two categories Multiplication and Division and provides descriptions of the input parameters.

    The attachment is a workbook that contains the code!
    Please shed some light on how to get this working!
    Thanx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UDF argument help! (Excel 2000 >)

    I gather that you are using Windows XP. The library path near the top of the code is not correct for Windows XP. It should be

    <code>Const Lib = """c:windowssystem32user32.dll"""</code>

    After this change, the code works for me - see screenshot.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: UDF argument help! (Excel 2000 >)

    I'm on Windows 2000 currently! I changed it to Const Lib = """c:winntsystem32user32.dll""" and it works great....
    Thanx

    So simple eh... just one small change to a path!!! These PC's really need to be spoon-fed....sheez, they just can't think for themselves!!! <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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