VBA: Disable double-click on form control (button)

Question

I have a VBA form in Excel with "Next" and "Previous" buttons that update an Image control's picture source.

I would like to be able to click these buttons very quickly in succession in order to loop through the images. However, when I click twice in short succession (double click) I only get one response.

I suspect that this is the case because there is a double click event on the button that gets triggered instead of the click event when two clicks are very close to each other.

My goal would be to disable the double-click event altogether, allowing me to click the button as quickly as I want. Is there a way to do that?

have you tried to put in your DoubleClick event set Cancel = True? — user8753746
– user8753746, Commented Nov 8, 2017 at 20:49

Excelosaurus · Accepted Answer · 2017-11-08 20:44:25Z

2

Intercept the MouseUp event instead.

answered Nov 8, 2017 at 20:44

Excelosaurus

2,8591 gold badge17 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

E. Villiger Over a year ago

Good idea, but doesn't work. Apparently the MouseDown is only called once per double-click.

Josh Eller · Accepted Answer · 2017-11-08 20:47:50Z

0

Regular command buttons might not be the best control; what you're doing sounds like it calls more for a spin button (the one with the next/back control).

If that doesn't cut it, the stupidly simple solution would be to have the double click even simply call the click event twice.

answered Nov 8, 2017 at 20:47

Josh Eller

2,0859 silver badges11 bronze badges

1 Comment

E. Villiger Over a year ago

Good point with the spin button; I'll look into that - and yes, calling the click event from double click works fine.

E. Villiger · Accepted Answer · 2017-11-08 20:53:20Z

0

I actually figured out a pretty easy workaround for this:

In the DoubleClick event, I can simply call the Click event like so:

Private Sub NextBtn_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    NextBtn_Click
End Sub

I am now able to click the button as fast as I want and after each click the same code is executed.

answered Nov 8, 2017 at 20:53

E. Villiger

92612 silver badges29 bronze badges

3 Comments

Mathieu Guindon Over a year ago

Invoking event handlers "manually" like this is a very strong sign that you're doing something wrong. Event handlers aren't normal procedures, they handle events.

E. Villiger Over a year ago

True; ideally I would call a function like "GoToNextImage" from both event handlers. (I was just too lazy for my purposes to create a separate function)

Mathieu Guindon Over a year ago

Yet handling the proper event makes a much more robust and elegant solution doesn't it :)

Collectives™ on Stack Overflow

VBA: Disable double-click on form control (button)

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related