+ Reply to Thread
Results 1 to 13 of 13

ListBox Item Uncheck issue

  1. #1
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    ListBox Item Uncheck issue

    Hi Experts,

    In the attached file I have created ListBox and it is working fine, if end user first uncheck the Item “All”. However if Item “All” is checked or selected then it is not allowing to uncheck any another Item from the list.

    How can I unselect Item “All” and particular unchecked Item from listbox, if end user unchecked the any another item.

    e.g. If Item “All” is selected (all item selected) and user unchecked the any another Item then Item “All” and that particular item need to be unchecked.

    Please refer attached file for details and code.

    Thanks in Advance
    Attached Files Attached Files
    /Rgds,
    Ganesh Pitale

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ListBox Item Uncheck issue

    Do you need to select all the other items when All is selected?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: ListBox Item Uncheck issue

    Yes, If Item "All" is selected then rest all item should be selected.

  4. #4
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: ListBox Item Uncheck issue

    But if any another item unchecked by user then that particular Item and "All" need to be unchecked.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ListBox Item Uncheck issue

    Why do they need to be selected?

    Can't you check if the All option has been selected in subsequent code.

  6. #6
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: ListBox Item Uncheck issue

    Actually I am unable identify the unchecked item number or index number of unchecked item when user unchecking/unselecting the item.

    e.g. I wanna create it like auto filter dropdown

    1) If All is checked then entire list should be selected
    2) If All is unchecked then entire list should be unselected (If all items are checked)
    3) If all items are checked and any one unchecked (other than "All") by user then only Item All and that particular item should be unchecked.

  7. #7
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: ListBox Item Uncheck issue

    Please Login or Register  to view this content.
    solved my problem

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ListBox Item Uncheck issue

    How did you solve it?

  9. #9
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: ListBox Item Uncheck issue

    Attached is the solution
    Attached Files Attached Files

  10. #10
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ListBox Item Uncheck issue

    Could you share the solution?

  11. #11
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: ListBox Item Uncheck issue

    Have you checked attached file ?

  12. #12
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: ListBox Item Uncheck issue

    No I'm unable to download it.

  13. #13
    Registered User
    Join Date
    06-16-2010
    Location
    India, Pune-411006
    MS-Off Ver
    Excel 2007/2010
    Posts
    89

    Re: ListBox Item Uncheck issue

    Attached again in this post, please check
    Attached Files Attached Files

+ 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] first item in listbox does not show in listbox
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2013, 10:33 AM
  2. [SOLVED] Removing item from one listbox to another Code Issue
    By MB_vba in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2013, 03:11 PM
  3. [SOLVED] Copy one listbox item to same index position in another listbox
    By Foreverlearning in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2012, 06:05 AM
  4. Multi select Listbox Items selection based on other Listbox item selection.
    By srinivassathi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2011, 05:53 AM
  5. Populate ListBox Based On Item Chosen In Another ListBox
    By davemojo82 in forum Excel General
    Replies: 1
    Last Post: 08-04-2009, 08:39 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