Nominal function in vb

GuillaumeJ

New Member
Joined
Mar 10, 2004
Messages
27
Hi everyone,

I would like to use the NOMINAL function (included in the Analysis vb toolpack) in one of my macros. Is there a way to have it available in vba ?

Thank you for your help
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
In case it isn't available in VBA, you could use the formulas:
Effective Rate, or APY:
APY = (1+%rate/# of periods/yr)^(# of periods/yr) - 1
Nominal rate, or rate:
Rate =((1+%APY)^(1/# of periods/yr) - 1)*(# of periods/yr)
 
Upvote 0
Yes, it's what I did actually but I was wondering how (or if) it is possible to get access in the VBA code to the worksheet functions included in addins, such as the analysis toolpack.
 
Upvote 0
I'm sorry that I cannot help you in VBA, but, I feel that someone else, who can, will pick this up. Good luck!
 
Upvote 0
In the VBA Editor goto Tools>References... and check atvbaen.xls.

You should then be able to use Nomimal in VBA.
 
Upvote 0

Forum statistics

Threads
1,211,852
Messages
6,104,367
Members
447,902
Latest member
chriswebs23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top