Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Speed button to wrap text | Excel Worksheet Functions | |||
Can you speed UP drag speed? | Excel Discussion (Misc queries) | |||
Speed | Excel Programming | |||
need for speed! | Excel Programming | |||
Speed? | Excel Programming |