calling an macro

[willie64]

i would like 2 know if one of you guys know "IF" it is possible 2 call an macro from the "FORMULA" line in excel....

a8y 4 the dummies:
the line within excel not vba where you put text r functions inside such as:

Please Login or Register  to view this content.

[Leith Ross]

Hello Willie64,

Functions placed in a VBA Module are the easiest to use since they return a value. That value then becomes the cell's value.

Example Macro Called from Excel:

A1 = 2
A2 = 5
Formula in A3
=AddTogether(A1, A2)

A3 = 5

Macro Code:

Public Function AddTogether(First_Number As Single, Second_Number As Single) As Single

AddTogether = First_Number + Second_Number

End Function

Hope this answers your question,
Leith Ross