Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

In you main workbook use:

Sub test() 
    ' Main Workbook
    Application.Run "ShowForm"
    Application.Run ("youraddin.xlam!ShowForm")
End Sub

In a separate Add-In:

Public Sub ShowForm() 
    ' youraddin.xlam Add-In
    MsgBox "Hello World!"
End Sub 

To Use With Arguments:

Sub test()
    ' Main Workbook
    Application.Run "MsgVar", "Hello World!"
End Sub
Public Sub MsgVar(msg)
    ' youraddin.xlam Add-In
    MsgBox msg
End Sub
  • No labels