UserForm Running - While Jumping to Application GoTo Statement - Unload

[Paul_Hossler]

Try this in the user form code

Private Sub CommandButton1_Click()
    
    sMacroToRun = ListBox1.Column(1)
    
    Me.Hide
    
    With Application
        .Run sMacroToRun
    End With
    
    Unload Me
    
End Sub

with this in the Macros module

Option Explicit

Public sMacroToRun As String
 
  
Sub UF_Show()
UFListBox.Show
End Sub