Sub Name as Variable

[vba_monkey]

Hello,

Does anyone know how to set the sub name as a variable? As in MyVariable = Sub Name.

Thanks

 

[Marcelo Branco]

Not clear what you're trying to do.

This?

Sub Main()
    Dim MySub As String
    
    MySub = "DoSomething"
    Application.Run MySub
End Sub

Sub DoSomething()
    MsgBox "Hello"
End Sub

M.

 

[vba_monkey]

When I say Sub Name I am referring to the the name of the Sub.

AS in

Sub Main()

MyVariable = Main

 

[Marcelo Branco]

When I say Sub Name I am referring to the the name of the Sub.

AS in

Sub Main()

MyVariable = Main

Yes, in my example above i assigned the variable MySub to the name of the other sub ("DoSomething")

M.

 

[vba_monkey]

The name of the Sub is Main so the variable should be set to Main

 

[Marcelo Branco]

The name of the Sub is Main so the variable should be set to Main

Ok, do it, but you need to clarify what you are trying to do.

M.

 

[vba_monkey]

What do you mean do it?

I'm trying to return the current sub name and set it as a variable, I'm sure of any other way to say it.

 

[Marcelo Branco]

I meant set the variable to the name you want/need, but i'm not understanding what you are trying to achieve.
Why do you need such variable? How do you intend to use it?

M.