newbie programming

  • Thread starter Thread starter Josh Ashcraft
  • Start date Start date
J

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
 
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
 
Back
Top