• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. kmzach

    How to make a help box for User Defined Functions

    Excel has provided formula help boxes for their built-in functions. I I make my own function, how do I make a help box for the User Defined Function?
  2. kmzach

    Help prompt for a UDF

    How can a help prompt be introduced for a User Defined Function (UDF)? What I mean is that when I type the name of the UDF in an Excel sheet, a help prompt should appear next to the cell giving some hint about the argument of the function that is to be input.
  3. kmzach

    Permutations and Combinations

    Can someone give the VB code for a macro to get all possible combinations of n items taking r items from it at a time? I am looking for the code to list all the nCr combinations
  4. kmzach

    Excel workbook received by e-mail gets stripped of its formulae

    On a particular computer, whichever Excel workbooks are received by e-mail, I notice that the formulas in the workbook loses its references and the #REF! error is displayed. However, on that same computer, Excel files copied directly using a pen drive does not show this error. Further, the...
Back
Top