Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 644
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 47
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Speed button to wrap text Sanjay Shah Excel Worksheet Functions 4 February 12th 07 07:22 PM
Can you speed UP drag speed? Ryan W Excel Discussion (Misc queries) 1 October 24th 05 06:09 PM
Speed tjh Excel Programming 1 December 16th 04 05:49 PM
need for speed! Neil[_19_] Excel Programming 1 May 19th 04 10:25 PM
Speed? Stu[_31_] Excel Programming 11 October 18th 03 09:41 PM


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"