LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 215
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
REPSOT?? Sub Worksheet_Change(ByVal Target As Range) Ed Davis[_2_] Excel Discussion (Misc queries) 14 October 13th 09 03:20 PM
ByVal Target Range Great Code but need Help Mark Excel Discussion (Misc queries) 31 July 27th 07 03:11 PM
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Arturo Excel Programming 2 January 7th 05 06:59 PM
what does (ByVal Target As Range) mean Zygoid[_7_] Excel Programming 6 January 31st 04 05:08 PM
Many Sub Worksheet_Change(ByVal Target As Range) In One Worksheet MathewPBennett Excel Programming 4 December 24th 03 01:01 PM


All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"