+ Reply to Thread
Results 1 to 5 of 5

Items in listbox not selected after first click

  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    8

    Items in listbox not selected after first click

    Hi there,

    I have a userform with several multiselect listboxes, all containing just one item.
    What I am experience now, is that the item in the listbox is not alwaays selected after clicking the first time on it. Sometimes it only sets the focus on it.
    After clicking a second time on it, then the listbox item is selected and is highlighted blue.


    Does anyone know a solution for this so that the item is always selected after the first click?
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Items in listbox not selected after first click

    Why are you not using Toggle Buttons?
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: Items in listbox not selected after first click

    Pretty pictures tell us nothing - workbook or code would be more use.
    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  4. #4
    Registered User
    Join Date
    12-02-2011
    Location
    Belgium
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Items in listbox not selected after first click

    OK everybody, I uploaded a sample workbook.
    Attached Files Attached Files

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,410

    Re: Items in listbox not selected after first click

    Inappropriate use of ListBoxes.
    torachan.

+ 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] Copy selected listbox items to another listbox
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2020, 10:42 AM
  2. [SOLVED] doble click to modify selected record in listbox and right click to delete
    By bluepomme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2019, 08:43 PM
  3. [SOLVED] Add Selected Items From One ListBox to Another ListBox on UserForm
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 06:53 PM
  4. Copy Selected items from multicolumn, multiselect listbox to another listbox
    By Willigb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 11:27 AM
  5. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM
  6. [SOLVED] How to use selected items from Listbox
    By gerard.kompier@shell.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2006, 11:10 AM

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