I see this from time to time and want to know what it is. I did try google, but its filtering out the characters from the search. I have a few books that don't reference it either.
FWIW, I remember in pascal that is was the assignment operator.
Can anybody point me to the MSDN or similar page?
You can use the := syntax to assign the parameters to a Sub or Function by name, rather than strictly by position. For example:
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
TestRoutine(Y:="TestString", X:=12)
End Sub
Private Sub TestRoutine(ByVal X As Long, Optional Y As String = "")
' Do something with X and Y here... '
End Sub
End Class
Note that TestRoutine specifies X as the first parameter, and Y as the second, but the call in Form1_Load has them in the opposite order, naming each parameter with the := operator.
Here's a link to an MSDN article on the subject:
http://msdn.microsoft.com/en-us/library/51wfzyw0.aspx
I don't see this used very often, except in VBA macros generated by Excel's macro recorder, which uses it a lot.
It's really useful when there are multiple optional parameters - you see that a lot in code that's callinginto the office object models - Word, Excel, etc. When you have 40 parameters with 37 of them optional, and you want to set values for parameters 34 and 40, it's a lot clearer to use := than to have a function call that looks like ("new", "settings", 1, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,43,,2,,,,,7)
I wanted to make this a comment to JeffK, but I don't have enough rep.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With