What the code in the brackets mean

**excelkeechak** · 04-16-2009, 07:28 AM

i m unable to understand what the code in the brackets mean(i think they are arguments, but what does they signify)

Please Login or Register  to view this content.

**DonkeyOte** · 04-16-2009, 07:35 AM

The first, Target, relates to the Range on which rightclick was activated... the latter Cancel is a Boolean that allows you to override the event itself as is the case in your example.

**excelkeechak** · 04-16-2009, 07:46 AM

Ok. But i still had some doubts regarding the same.what does the code in the brackets mean. i had studied many examples on the net but unable to Understand them.

Could u please elaborate in detail.here in the given example above where is the range defined.
i Could not understand the keywords (By Ref, By Val) appearing in most of the examples.also do tell me in which cases will it be useful and when they are used.

**DonkeyOte** · 04-16-2009, 07:48 AM

see: http://msdn.microsoft.com/en-us/libr...30(vs.71).aspx

**Andy Pope** · 04-16-2009, 07:50 AM

The help explains

ByVal:
by value
A way of passing the value of an argument to a procedure instead of passing the address. This allows the procedure to access a copy of the variable. As a result, the variable's actual value can't be changed by the procedure to which it is passed.

ByRef:
by reference
A way of passing the address of an argument to a procedure instead of passing the value. This allows the procedure to access the actual variable. As a result, the variable's actual value can be changed by the procedure to which it is passed. Unless otherwise specified, arguments are passed by reference.