Thread: NoPrompt
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default NoPrompt

That is it,

If NoPrompt Then

is the same as

If NoPrompt = True Then

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Oldjay" wrote in message
...
I can't find where the varable NoPrompt is defined. I have searched the

whole
project.

I have found

If NoPrompt Then
JobNumber = "\\SERVER3\Jobs\Estimate1\NEW_JOBS1\" & Numbersave
Else
JobNumber = InputBox("Please enter JOB file name to save",

"The
d Company", "\\SERVER3\Jobs\Estimate1\NEW_JOBS1\" & Numbersave)
End If

"Bob Phillips" wrote:

It means that the macro tests a variable NoPrompt. The macro will assume

it
is set to False, but when calling the macro, you can pass a value of

True to
force a different action.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Oldjay" wrote in message
...
What does the following code mean "(Optional NoPrompt As Boolean =

False)"
in
this line of code?

Sub SaveNewJob(Optional NoPrompt As Boolean = False)