Odd assignment operator in aging VBA macro

M

M Ferguson

I'm a Java/C# dev who has been given some ancient VBA
macros to reproduce in another application, and I am
seeing what seems to be an assignment operator := which
I am not familiar with. Does this operator have any
particular significance that I should know about?
Unfortunately it can't be searched in any search engine
I've tried because it contains only punctuation.

Thanks for your help
M Ferguson
 
S

Steve Jorgensen

In VB and VBA, the := operator is used to specify the passing of arguments by
name rather than by position. This notation is often used when passing
parameters to a procedure with many omitted optional parameters or when the
meanings of the parameters passed would not be obvious from the names or
values of the arguments.

For more info, loook in the help under "Visual Basic Conceptual Topics" /
"Calling Sub and Function Procedures", and find the section called "Passing
Named Arguments".
 
Top