?
Solved

Sign ' := ' in vba

Posted on 2016-09-06
4
Medium Priority
?
35 Views
Last Modified: 2016-09-06
What is the ' :=' sign in excel Vba ? Is it some sort of operator ?
0
Comment
Question by:Shrikant Dixit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 47

Expert Comment

by:Wayne Taylor (webtubbs)
ID: 41786918
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
 

Author Comment

by:Shrikant Dixit
ID: 41787044
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
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 2000 total points
ID: 41787056
0
 

Assisted Solution

by:Shrikant Dixit
Shrikant Dixit earned 0 total points
ID: 41787144
Dear Mr. Taylor,
Thanks a lot. Now I am fully satisfied. My question is resolved.
Shrikant Dixit
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an Add-On procedure to be used in conjunction with the code provided in Reducing EE Email Clutter using Outlook (http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_3146-Outlook-Processing-EE-emails-on-Receive.…
Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question