Excel Macro button not show macro with parameter

0
votes

I am new to Excel macro, I try to write a testing macro named Test without parameter, and then in Excel workbook, press the macro button, the testing macro is shown as follow:

enter image description here

enter image description here

but if I add a parameter to the macro Test as 

Public Sub Test(var1 As String)

then when I return to the workbook, press the macro button, the Test macro is not shown, why? Is macro cannot with parameter?

enter image description here

enter image description here

1
excelvba
Have a look at this answer ... stackoverflow.com/a/31845993/5040941 – 3-14159265358979323846264

1 Answers

1
votes

The macro is not shown because you have forced a parameter to be passed as part of the procedure, thus rendering the procedure unavailable to be run on a stand-alone basis.