VBA help with function formulas

**Chris Hansen** · 10-20-2009, 09:09 AM

I'm taking a course in excel where we also need vba, i have the basics in place.

All the formulas my teacher makes demands that you remember in what order you enter your variables - Normally when using a function in excel it tells you in what order you put in the variables.

I know this is possible in vba, but not sure how.

example, using vba to calculate blackScholes formula.

Please Login or Register  to view this content.

When i in excel write =blackScholes then I insert the variables S,x,r,T, sigma, but i would like excel to to tell me in what order, by showing a letter of S,x,r,T or sigma

Anyone who can help me?

**Ron Coderre** · 10-20-2009, 09:52 AM

Originally Posted by Chris Hansen

When i in excel write =blackScholes then I insert the variables S,x,r,T, sigma, but i would like excel to to tell me in what order, by showing a letter of S,x,r,T or sigma

Anyone who can help me?

If you use the function wizard (by clicking the Fx button on the formula bar),
the function arguments will display.
OR
After you type the function name through the left parenthesis,
CTRL+A to see the arguments.

Does that help? ...or are you looking for something else?

**tony h** · 10-20-2009, 10:06 AM

what library are you using for your blackscholes function?

**Chris Hansen** · 10-20-2009, 11:41 AM

@Ron

Yes this gives me the information i need - but why doesn't is show automatically -Can i force it?
When you use excels own formulas it shows the "help" right at the line you are typing...

@Tony - library, remember i just know the basics about writing a "code" :-)