Sign ' := ' in vba

What is the ' :=' sign in excel Vba ? Is it some sort of operator ?
Shrikant DixitAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
It's used to specify the values for the arguments in a function. It has no other direct meaning.

An example (copying worksheets) on it's use is....

    Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")

...which creates a copy of Sheet1 and places it after Sheet3. It can also be written like this...

    Worksheets("Sheet1").Copy , Worksheets("Sheet3")

Note the comma. When not specifying the argument as in the first example, arguments must be in the function order, which for the Worksheet.Copy function is ([Before], [After]).
0
 
Shrikant DixitAuthor Commented:
Dear Mr.Taylor,
Thank a lot. I wonder why nothing is said about this in msdn or any other litrature.
Thanks again.
Shrikant Dixit
0
 
Shrikant DixitAuthor Commented:
Dear Mr. Taylor,
Thanks a lot. Now I am fully satisfied. My question is resolved.
Shrikant Dixit
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.