ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Button Speed (https://www.excelbanter.com/excel-programming/370183-button-speed.html)

Matthew

Button Speed
 
I have a userform with some buttons, used for data entry. Buttons are very
fast if you click one and then a different one. However when you try
clicking the same button more than once there is a delay.

If I was entering a number (using the buttons) 11542, I would quickly click
button 1 twice but it only registers as once unless I wait a second or so
between clicks, I can click buttons 5,4 and 2 as qucikly as I like and they
register.

Is it possible to remove this delay?

TIA

Die_Another_Day

Button Speed
 
I believe it is a "Double Click" thing. Try adding this code to the buttons
"DblClick" Event:
CommandButton1_Click
Change CommandButton1 to your button name obviously.

HTH

Charles Chickering
"Matthew" wrote in message
...
I have a userform with some buttons, used for data entry. Buttons are very
fast if you click one and then a different one. However when you try
clicking the same button more than once there is a delay.

If I was entering a number (using the buttons) 11542, I would quickly
click
button 1 twice but it only registers as once unless I wait a second or so
between clicks, I can click buttons 5,4 and 2 as qucikly as I like and
they
register.

Is it possible to remove this delay?

TIA




Matthew

Button Speed
 
That works a treat!

Thanks...

"Die_Another_Day" wrote:

I believe it is a "Double Click" thing. Try adding this code to the buttons
"DblClick" Event:
CommandButton1_Click
Change CommandButton1 to your button name obviously.

HTH

Charles Chickering
"Matthew" wrote in message
...
I have a userform with some buttons, used for data entry. Buttons are very
fast if you click one and then a different one. However when you try
clicking the same button more than once there is a delay.

If I was entering a number (using the buttons) 11542, I would quickly
click
button 1 twice but it only registers as once unless I wait a second or so
between clicks, I can click buttons 5,4 and 2 as qucikly as I like and
they
register.

Is it possible to remove this delay?

TIA






All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com