Application.Run Calling subroutine in a UserForm with a variable

[Carl2000]

Good evening
I am using Excel 2019 and have a UserForm named UserForm 1.

I wish to run a subroutine stored in the UserForm using a variable created in another subroutine in the UserForm. eg.

Option Explicit
Public Test As String

Private Sub1()
Test = "Sub2"
Application.Run Test
End Sub

Private Sub2()
' Subroutine actions
End Sub

I can use Application.Run to run a subroutine called Sub 2 in Module 1 but can't figure out how to run it in my userform code.

Unfortunately I wasn't able to work it out from previous posts on this forum.

Many thanks

 

[NdNoviceHlp]

Hi Carl2000 and Welcome to the Board! You can run the Sub2 from the userform Sub1 code by placing Sub2 in a module and designating it as a public sub (ie. Public Sub2). HTH. Dave

 

[Carl2000]

Hi Carl2000 and Welcome to the Board! You can run the Sub2 from the userform Sub1 code by placing Sub2 in a module and designating it as a public sub (ie. Public Sub2). HTH. Dave

Many thanks for your assistance

 

[NdNoviceHlp]

You are welcome. Thanks for posting your outcome. Dave