Word VBA - Call Private Sub on userform from module

[hermanlaksko]

I have tryed:
Application.Run UserFormName & "." & "Private Sub Cmd_Save_Click"
But get the error msg: Unable to run the specified macro
I know that the Sub is there and Application.Run should do the trick.
So what am I doing wrong or cat this be done owing to the fact that this is a private sub ?

Herman
Say no to macros

 

[strongm]

>I know that the Sub is there and Application.Run should do the trick.

Application.Run basically cannot call class methods. And a form is a class ...

CallByName works, though, but the first parmeter needs to be the object in question, not a string (but that's OK, becasue we've covered how to get to the form object from string name in thread707-1783526)

CallByName UserForm1, "CommandButton1_Click", VbMethod

 

[Andrzejek]

Or you can do this ( I think.... I hope....):

Option Explicit
...
Private Sub Cmd_Save_Click()
Call [blue]MySaveMagic[/blue]
End Sub
...

and in the standard Module:

Option Explicit
...

Public Sub [blue]MySaveMagic[/blue]()[green]
    'My code to save stuff...[/green]
End Sub
...

Then you just do: [tt]Application.Run [blue]MySaveMagic[/blue][/tt]


---- Andy

There is a great need for a sarcasm font.

 

[strongm]

> I think.... I hope....

oops ... it would be

Application.Run "MySaveMagic"