Call FS function from Excel macro

pacific
2009-10-21
2013-04-17
  • pacific
    pacific
    2009-10-21

    Hi,
    Is it possible to reference the FS function from an Excel macro in the same way that the Average function is called below?
    I need to call the FS function from a menu.
    Thanks

    Sub test()
        ActiveCell = Application.Average(1, 5)
        ActiveCell = Application.FS("Math.random")
    End Sub

     
  • Peter Smith
    Peter Smith
    2010-04-14

    Hi,

    You need to do something like the following:

    Private Sub CommandButton2_Click()
        ActiveCell.Value = Application.Run("FS", "test")
    End Sub

    Cheers,
    Peter