Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Oldjay,
You have find where this Sub is called from, where presumably you will find: SaveNewJob True or Call SaveNewJob(True) NickHK "Oldjay" wrote in message ... My problem is what changes NoPrompt to true. I can't find any referenceto it except the If- Then - Else "Tom Ogilvy" wrote: This is a function, so NoPrompt is a placeholder. Any Boolean variable or boolean constant may be passed to the function - the variable does not have to be call NoPrompt. Also, since the variable is shown as an optional argument, the calling functions are not required to pass any variable. -- Regards, Tom Ogilvy "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) |