Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
frm Excel 97 to 2003
ActiveCell.Value = Application.InputBox("If you wish to change th
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 Amortizatio Schedule. I switched to MS Office Pro 2003 and it doesn't bring up the box an more. any help out there -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
frm Excel 97 to 2003
gordyb31
I'm using office 2000 with xp home and your code works. Hopefully someone using 2003 will answer your question. Charle -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
frm Excel 97 to 2003
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
frm Excel 97 to 2003
I use xl2002 and your code caused a problem in that, too.
expression.InputBox (Prompt, Title, Default, Left, Top, HelpFile, HelpContextId, Type) I like to use the named parms (instead of positional parameters): ActiveCell.Value = Application.InputBox _ (prompt:="If you wish to change the payment, type in the payment " & _ "and hit ENTER:", _ Title:="EDITING PAYMENT", _ Default:=Format(ActiveCell.Value, "#,###.00"), _ Left:=190, Top:=-60, Type:=1) I don't recall that application.inputbox changed, but if it did, then using the names might be the best way to go. But if it didn't change, this would work, too: 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) Notice the extra commas--to reserver those positional parameters. "gordyb31 <" wrote: 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/ -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
frm Excel 97 to 2003
Thankyou both.
Looks like either one will work but I'll try it a little more. Thanks, Gord -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 versus Excel 2003 & Excel 97-2003 fully compatible | Excel Worksheet Functions | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |