VBA userforms

[beridivya]

Hi there

Can you Explain the following code-
Private Sub lstSheets_DblClick(ByVal Cancel As MSForms.ReturnBoolean).
I have confusion regarding the statement "ByVal Cancel As MSForms.ReturnBoolean".Why do we use the variable name "Cancel" here? Also tell me what happens when I pass the argument value "True" and when I pass the value "False".

thanks
Divya

 

[CautionMP]

beridivya,

The DblClick procedure is passed a True/False argument named Cancel. If code in the event procedure sets Cancel to True, the control ignores the second click. You would use this with controls, such as an OptionButton, for which clicking would change its value, and double-clicking would change its value twice, to return it to the original setting. By setting Cancel to True, you could have a double-click change the value of the control (because only the first click is registered) while still firing the DblClick event.

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)