Calling a VSTA macro with parameters / reference to calling object

Calling a VSTA macro with parameters / reference to calling object

Hello,
Is there any way to add parameters to a VSTA macro or any reference from the calling object?
I want to write a universal macro wich is called in different windows (during runtime) and manipulates runtime-variables specific to that window.
But without any reference from where this macro is being called (or at least hard-coded params) there is no way for me to determine wich variables should be manipulated.
For example I have a macro like this:
[VBNET]Public Sub Macro_Test(ByVal sender As Object)
MsgBox("test")
End Sub[/VBNET]
I can see this macro in the editor and can bind it to a button, but it isn't called during runtime when pressing the button.
Thanks in advance.

This is a migrated post! Originally posted on 02.05.2012 by user ptk_mzeh. Please be aware that information can be outdated.