Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I just found an old sample I was trying to adapt for a message box. But, in my new spreadsheet, the macro crashes when I try to run it. It stops on the Default command and says "assignment to constant not permitted". What am I forgetting? Here is the macro:
Message = "ENTER LONG DISPLAY NAME OF WRAP MANAGER" Title = "" Default = "" MGR_LONG_NAME = InputBox(Message, Title, Default) Sheets("INPUTS").Range("C11").Value = MGR_LONG_NAME Thanks, Grace |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate the amount of time over a permitted amount (12 hours) | Excel Discussion (Misc queries) | |||
How to give an error message if a cell value entered is larger than permitted | Excel Discussion (Misc queries) | |||
Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
point assignment | Excel Discussion (Misc queries) | |||
Key Assignment Log | Excel Discussion (Misc queries) |