View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grace[_4_] Grace[_4_] is offline
external usenet poster
 
Posts: 106
Default Assignment to constant not permitted

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