[Josh Ashcraft]

I need some help guys, first off, i need to know how to
pull individual cell values into vba as variables.

second, is it possible to call a function in excel in vba,
i need to be able to do a loan calculation when a command
button is pressed.

thanks,
Josh Ashcraft

[Don P]

Josh,

This macro does both, pulls cell values as variables and calculates a loan
payment.

Sub test3()
payment = Application.WorksheetFunction.Pmt(Range("a1"), Range("a2"),
Range("a3"))
End Sub

Don Pistulka


"Josh Ashcraft" wrote in message
...
I need some help guys, first off, i need to know how to
pull individual cell values into vba as variables.

second, is it possible to call a function in excel in vba,
i need to be able to do a loan calculation when a command
button is pressed.

thanks,
Josh Ashcraft