Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ByVal Target As Range
In standard worksheet and workbook events, the Sub argument lists include
some "mysterious" argument components, such as: ByVal Target As Range, Cancel As Boolean, ByVal Sh As Object, etc. The VBA Help states that ByVal (and ByRef) can be used with Call only when calling a DLL procedure !! a. Do standard / custom events automatically call a DLL procedure, and thus their argumentlist must include ByVal ?? b. Are Target, Cancel, Sh, Wn, etc. Keyword variable names ?? c. Can one use, for example, the variable name Target in the procedure ?? after assigning an object reference to it: Set Target = ?? d. If Target is not used or can not be used, can one omit Target As Range from the argumentlist ?? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REPSOT?? Sub Worksheet_Change(ByVal Target As Range) | Excel Discussion (Misc queries) | |||
ByVal Target Range Great Code but need Help | Excel Discussion (Misc queries) | |||
Private Sub Worksheet_SelectionChange(ByVal Target As Range) | Excel Programming | |||
what does (ByVal Target As Range) mean | Excel Programming | |||
Many Sub Worksheet_Change(ByVal Target As Range) In One Worksheet | Excel Programming |