addin VBA Function

[jamiguel77]

hi friend i have this function:

Function calcularMeses(date1 As Date, date2 As Date) As Integer
On Error Resume Next
Application.Volatile True
Dim xMEses As Integer
xMEses = 0

If Dia(date2) >= Dia(date1) Then
xMEes = (año(date2) - año(date1)) * 12 + mes(date2) - mes(date1)
End If
calcularMeses = xMEses
End Function


i do this steps:

Copy the above vba code
Open a new excel file
Right click on any sheet tab name and select “view code” option.
Don’t be scared of the VBA editor. Take a deep breath.
Click on “Insert” menu option and select “Module”
Paste the code in the new module
Press ctrl+s to save the work book. Specify “excel add-in” as the file type. i saved as: calcularMeses.xlam
Now, go back to excel and install this new add-in
That is all. Now you can use calcularMeses formula in your workbooks.


installed, closed excel, opened again, check if calcularMeses.xlam is installed but never of never i see the function..... =calcu (not autocomplete or suggest me)


any advice?

thanks

 

[jproffer]

Well first, don't put it in the sheet code module. Second if this is the only function you need to use, you don't need an add-in...you can put it in the personal macro workbook, or put it in the workbook you need it in...but put it into a regular code module. Alt+F11, Insert-Module. Paste it there.