BeforeSave event

[Darchcruise]

Hello,

I am new to VBA, and reading a book by John Walkenbach. In page 160 he has a paragraph called "BeforeSave event for a workbook".

Question:
Can someone translate and explain to me what this line of code means in English/simple terms?

(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Thanks

 

[kpark91]

so basically, SaveAsUI translates to "Save As User Interface" and Cancel translates into "Cancel" (duh..)

As Boolean describes variables' types which are obviously Booleans.

Booleans are variable types which only allow values of "True" or "False" to be stored in the variable. In VBA, 0 is recognized as False and all the other values are recognized as True.

So, if you have a code like

Cancel = 0

this would be equivalent as saying

Cancel = False

Anyways, in this event, if you look to this website:
http://msdn.microsoft.com/en-us/library/aa220840(v=office.11).aspx

SaveAsUI (when set as True) will pop up a save as dialog for the user to choose a directory to save the file in and which format to save the file in..
while if the Cancel is set as True, the saving process will immediately stop, meaning save will never ever happen.

 

[Darchcruise]

I'm not sure I understand that completely.

Here is the full code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI _
As Boolean, Cancel As Boolean)
Sheets(“Sheet1”).Range(“A1”).Value = _
Sheets(“Sheet1”).Range(“A1”).Value +1
End Sub

How does the SaveAsUI As Boolean, Cancel As Boolean work in this code?

Thanks