Bill,

I guess that it is telling you that Default is a reserved word that you
cannot now use as a variable name.

The other looks like testing a string for False won't work. Try changing the
declaration of LotReq to variant.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bill C" wrote in message
...
I wrote a macro using Excel 5.0 and it has been running great for several
years using 5.0 but client has upgraded to newer version of Excel and
problems exist.
Dim LotReq As String
Message = "Choose ""OK"" For All Lots, Or " & Chr(13) & "Enter
Lot Number Requested."
Title = " CHOOSE LOT"
Default = "ALL"
LotReq = InputBox(Message, Title, Default)
If LotReq = "" Or LotReq = False Then EndAll

The following statements are not working:
Default = "ALL" ( get error about const assignment )
If LotReq = "" Or LotReq = False Then EndAll ( stops program )
Also Excel appears to be returning "false" on this statement when Pmts =
0.00
If Pmts = False Then EndAll

I do not have access to current Excel program. Can anyone spot the
problem?

TIA,
Bill C.