ByVal Button As Integer, ByVal Shift As Integer

[SuitedAces]

ByVal Button As Integer, ByVal Shift As Integer

For activeX controls what are these two arguments and what are they used for ?

Are they actually considered to be arguments ?

ByVal X As Single and ByVal Y As Single give you the position of the mouse ,
so unlike an argument you do not provide a value, instead they are variables giving you a value.

[Norie]

What context are you using these in?

A button event?

Another event?

[Leith Ross]

Hello SuitedAces,

These are indeed arguments. They are return values supplied by the event procedure. In this case, a Mouse Event. You can use these return values in your code to further refine the code operation. Button will identify which mouse button was clicked when the event was triggered. Shift will return a code that tells you which combination of keys (SHIFT, CTRL, and ALT) were pressed when the mouse was clicked.

Arguments can be passed in two ways: ByVal, or ByRef. If ByRef is the default in VBA. This simply passes the address of the object as an argument. ByVal passes the entire object. I won't go into the "why" as it would require its own post to explain.

Sincerely,
Leith Ross

[SuitedAces]

Hello SuitedAces,

These are indeed arguments. They are return values supplied by the event procedure. In this case, a Mouse Event. You can use these return values in your code to further refine the code operation. Button will identify which mouse button was clicked when the event was triggered. Shift will return a code that tells you which combination of keys (SHIFT, CTRL, and ALT) were pressed when the mouse was clicked.

Arguments can be passed in two ways: ByVal, or ByRef. If ByRef is the default in VBA. This simply passes the address of the object as an argument. ByVal passes the entire object. I won't go into the "why" as it would require its own post to explain.

Sincerely,
Leith Ross

Ok Leith so are you saying that Shift will not give me a value unless I have one of the mouse buttons pressed before a key press(Shift,ctrl,Alt) ?

[Leith Ross]

Hello SuitedAces,

The Shift argument in the Mouse Event is only returned when the Mouse Event fires. The Shift argument is also returned for Key Events (KeyDown, KeyPress, KeyUp). Again the value is returned only when the event takes places.

Sincerely,
Leith Ross

[SuitedAces]

Leith thank you for your help once again

[SuitedAces]

What context are you using these in?

A button event?

Another event?

yes I was looking at those in event for controls