vba - 以编程方式运行 "Assign Macro"对话框

Question

我正在创建宏工具，允许以编程方式在 Excel 中创建按钮，但最后我需要调用“分配宏”对话框:

让用户选择他想要分配给创建的按钮的宏。我怎样才能实现这一目标？

实际代码:

Dim btn As Shape
Set btn = wsSheetToAddButton.Shapes.AddFormControl(Type:=xlButtonControl, Left:=buttonLocation.Left, Top:=buttonLocation.Top, Width:=128, Height:=75)
With btn
    With .TextFrame.Characters
        .Caption = buttonText
        With .Font
            .FontStyle = "Bold"
            .ColorIndex = textColor
        End With
    End With
.Select
End With

Answer 1

选择按钮后添加此内容:

Application.Dialogs(xlDialogAssignToObject).Show