AnsweredAssumed Answered

How to run Excel Add-In functions and How to create a VBA Macro in VEE

Question asked by omar on Mar 31, 2014
Latest reply on Apr 8, 2014 by dBdetlef
Hello All,

I have two questions?

1)  how can i call a function of an Excel-Add-In using Vee, for example how to call Select_Color_MsgBox() from TestAddin.xlam (see the attached picture).

2)  using Vee-Formula how can i create a macro with parameters in a workbook and run it 
     there is the example "CreateVbaMacro" that uses a simple code in a formula, but i want to create a code  with parameters and many lines such as:

         Sub Select_Color_MsgBox(title As String, parm2 As Integer)
'
' Select_Color_MsgBox Macro
' Example macro by Agilent Technologies
'

'
    ActiveCell.Offset(3, 2).Range("A1:C6").Select
    Selection.NumberFormat = "$#,##0.00_);($#,##0.00)"
    Selection.Borders(xlDiagonalDown).LineStyle = xlNone
    Selection.Borders(xlDiagonalUp).LineStyle = xlNone
    With Selection.Borders(xlEdgeLeft)
        .LineStyle = xlContinuous
        .Weight = xlThin
        .ColorIndex = xlAutomatic
    End With
    With Selection.Borders(xlEdgeTop)
        .LineStyle = xlContinuous
        .Weight = xlThin
        .ColorIndex = xlAutomatic
    End With
    MsgBox Prompt:="Some Prompt Text for the message box", Buttons:=vbOKOnly, title:=title
        
End Sub


I would really appreciate any help.  

Attachments

Outcomes