Forum Discussion

Marc_G2's avatar
Marc_G2
Copper Contributor
Oct 13, 2023

Can't run Form-Control-with-argument macro for no discernable reason

Update.  I'm 99% sure the issue was somehow caused by me attempting to digitally sign my macro enabled document.  I had done so repeatedly since I kept getting invalid signature errors.  Clearing the...
excel
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
Oct 13, 2023

Marc_G2

Is TestFunc also the name of a module in that specific workbook?

Or could there be another name conflict?

 

As a workaround you could create a macro

Sub MyMacro()
    Call TestFunc("abc")
End Sub

and assign this macro to the command button.

  • Marc_G2's avatar
    Marc_G2
    Copper Contributor
    Oct 13, 2023
    The name of the module is something else. I've also tried moving the function to a different module which has no effect. And yes, I could use that as a workaround.

    I'm thinking there might be a weird config problem or something might be corrupted. If go back to a much older version of the document, the problem isn't there.
    • Marc_G2's avatar
      Marc_G2
      Copper Contributor
      Oct 13, 2023
      I created a copy of document and deleted everything except for the test function. I've also removed all library references. The issue persists...
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 13, 2023

        Marc_G2 

        Could you a copy of the workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources