+ Reply to Thread
Results 1 to 4 of 4

Forms Listbox only works on change

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    Cape Town, South Africa
    MS-Off Ver
    10
    Posts
    2

    Forms Listbox only works on change

    I'm using a Forms Listbox.
    If the item is already selected the mouse click doesn't generate a change event. But a double click does.

    How do I get a consistent event trigger on clicking an item, irrespective of whether the item is already selected?

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Forms Listbox only works on change

    Perhaps a mouse_up event?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    03-02-2017
    Location
    Cape Town, South Africa
    MS-Off Ver
    10
    Posts
    2

    Re: Forms Listbox only works on change

    Thanks Arkadi.
    I've been trying to use the mouse up or down events but haven't figured out how.

    I'm using the Form control, not the ActiveX control
    (The ActiveX controls have the annoying habit of resizing themselves on different monitors which renders them useless for my application)

  4. #4
    Registered User
    Join Date
    08-09-2015
    Location
    CzR
    MS-Off Ver
    MS Office 2013
    Posts
    41

    Re: Forms Listbox only works on change

    First thing to do is find the MS help to mousedown event procedure, it might give answers to your questions.

    Caution - you need to trigger the keyboard, too. The user can browse the listbox with up/down arrows and can press Enter on the selected row.

+ 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. [SOLVED] Listbox and textbox on different forms
    By molesy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-13-2014, 06:24 AM
  2. Update listbox (forms)
    By Zurn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2013, 03:02 PM
  3. [SOLVED] Run a macro when I select a value from a listbox (Forms Control)
    By connieb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2013, 08:53 PM
  4. ListBox != Forms.ListBox.1?
    By briandavid78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2013, 04:46 PM
  5. Forms and listbox
    By phschris1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2011, 10:32 PM
  6. Mail merge works with Forms but not with Labels
    By abbaszaidi in forum Excel General
    Replies: 2
    Last Post: 06-29-2005, 11:28 AM
  7. Unprotect from Forms Listbox
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2005, 02:06 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