The part where you are formatting the active cell seems to be the problem.
This part works fine for me in 2003:
ActiveCell.Value = Application.InputBox("If you wish to change the payment,
type in the payment and hit ENTER:", "EDITING PAYMENT")
What is "190, -60, 1" trying to accomplish?
"gordyb31 " wrote in message
...
ActiveCell.Value = Application.InputBox("If you wish to change the
payment, type in the payment and hit ENTER:", "EDITING PAYMENT",
Format(ActiveCell.Value, "#,###.00"), 190, -60, 1)
This from a program I wrote in Excel 97. It's for an Amortization
Schedule.
I switched to MS Office Pro 2003 and it doesn't bring up the box any
more.
any help out there.
---
Message posted from http://www.ExcelForum.com/