![]() |
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 |
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 |
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