+ Reply to Thread
Results 1 to 3 of 3

Click v double click event code

  1. #1
    Registered User
    Join Date
    07-02-2011
    Location
    Adelaide
    MS-Off Ver
    Excel 2010
    Posts
    4

    Click v double click event code

    Hi,

    I am working on a Windows 8.1 tablet invoicing spreadsheet using Excel 2013. Rather than use the Windows 8 keyboard I have created my own custom keyboard using a userform and a qwerty key layout. The text typed appears in a textbox which controls a listbox of customer names. It works very well until I repeat click the same letter. E.g. Goodwood. The command button is slow to react with a second press (or click). This slows data entry for the user. I presume this is due to the click v double click event code.

    Example code used:
    Please Login or Register  to view this content.
    Could anyone offer some ideas on how I can overcome this problem please?

    Thanks.
    Regards, Greg
    Last edited by vlady; 05-08-2014 at 09:55 PM. Reason: use code tags around codes.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Click v double click event code

    Could you just duplicate the code for the double_click event?

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    07-02-2011
    Location
    Adelaide
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Click v double click event code

    Works beautifully.

    Thanks very much for your help AlphaFrog.

    Cheers, Greg

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Changing cell properties with double click, then revert with another double click
    By mweber2525 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-01-2014, 01:40 PM
  2. Double Click Event Help
    By mannymg in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-13-2014, 02:56 PM
  3. double click event
    By DTrain9481 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-10-2009, 12:41 PM
  4. Double click event
    By baz0912 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2008, 05:56 PM
  5. userform label double-click goes to click event
    By John Paul Fullerton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2006, 01:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1