Results 1 to 9 of 9

UDF Description and UDF Arguments Descriptions Not Saving with Application.MacroOptions

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2021
    Location
    US
    MS-Off Ver
    16
    Posts
    6

    UDF Description and UDF Arguments Descriptions Not Saving with Application.MacroOptions

    I am trying to add function and argument descriptions to some custom functions using Application.MacroOptions. I put an example below. The macro runs fine, but after saving and closing Excel, the descriptions are gone. How do you make the descriptions remain after closing the application?

    Sub DescribeFunction()
    
       Dim FuncName As String
       Dim FuncDesc As String
       Dim ArgDesc(1 To 7) As String
    
       FuncName = "BilinInterp"
       FuncDesc = "This function does a double interpolation given x and y ranges."
       ArgDesc(1) = "Select the range of X values. Must be in one row."
       ArgDesc(2) = "If XRange values are in ascending order then TRUE. Descending order is FALSE."
       ArgDesc(3) = "Select the range of Y values. Must be in one column."
       ArgDesc(4) = "If XRange values are in ascending order then TRUE. Descending order is FALSE"
       ArgDesc(5) = "Enter the X value for interpolation."
       ArgDesc(6) = "Enter the Y value for interpolation."
       ArgDesc(7) = "Select the range of data in the table. Do not include XRange and YRange."
    
       Application.MacroOptions _
          Macro:=FuncName, _
          Description:=FuncDesc, _
          ArgumentDescriptions:=ArgDesc
    
    End Sub
    Last edited by footballfan22; 01-05-2021 at 03:43 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Application.MacroOptions Help File Question
    By phapronulu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2016, 05:22 PM
  2. Application.MacroOptions: StatusBar property not working
    By greglittle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2012, 12:56 AM
  3. Copy Name with description in a cell as many times descriptions come in a range
    By brajpalshishodia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2012, 12:31 PM
  4. Replies: 0
    Last Post: 08-16-2012, 02:01 PM
  5. Providing "descriptions" for VBA User Function Arguments
    By Mark@Work in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2006, 11:14 AM
  6. application.dialogs(xlDialogPrint) - arguments
    By David in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2005, 03:05 AM
  7. passing arguments by postion through application.run
    By ben in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2005, 09:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1