edate function in VBA

F

fdiez67

Is it possible to use edate function in VBA? I tried
WorksheetFunction.edate = ... and that doesn't work. TIA.
 
M

merjet

Is it possible to use edate function in VBA? I tried
WorksheetFunction.edate = ... and that doesn't work. TIA.
Click to expand...

That particular worksheet function is not accessible in
VBA. You can find out which ones are accessible by
using the Object Browser.

Merjet
 
B

Bob Phillips

Try something like

MsgBox Format(Application.Evaluate("edate(A16, 5)"), "dd mmm yyyy")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
C

Chip Pearson

The EDate function is part of the Analysis Tool Pak add-in. To use it in
VBA, you need to first load the "Analysis Tool Pak - VBA" add-in in Excel.
Then, open your VBA project, go to the Tools menu, choose Reference, and put
a check next to ATBVBAEN.xls item. Once you do this, you can access the
function directly. E.g.,

Dim Res
Res = edate(Now, 3)
Debug.Print Res


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top