VBA User defined subroutine description

Question

Do you know what is the limit of chars for the Description argument of the Application.MacroOptions method. There is no official info here: https://learn.microsoft.com/en-us/office/vba/api/excel.application.macrooptions

Tim Williams · Accepted Answer · 2021-12-10 17:21:13Z

2

You can test this pretty quickly. I got an error once n passed 255.

Function TestMacro()
    MsgBox ActiveWorkbook.Name
End Function
 

Sub AddUDFToCustomCategory()
    Dim n As Long
    For n = 1 To 500
        Application.MacroOptions Macro:="TestMacro", Description:=String(n, "x")
    Next n
End Sub

answered Dec 10, 2021 at 17:21

Tim Williams

169k8 gold badges104 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

John Snow Over a year ago

Thanks for the answer! I asked this question as my description in the Macro dialog (opens after clicking Developer->Macros) has reached the limit and I am pretty sure that I did not used 255 characters there.

Collectives™ on Stack Overflow

VBA User defined subroutine description

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related