+ Reply to Thread
Results 1 to 7 of 7

Clearing List Box Selection

  1. #1
    Forum Contributor
    Join Date
    01-04-2016
    Location
    Newcastle
    MS-Off Ver
    2016
    Posts
    107

    Post Clearing List Box Selection

    Right so when a clear button is hit I want it to clear my selection from my list box, to do this I'm currently using

    Please Login or Register  to view this content.
    However, this only clears one of my selections the list box i'm using is a Multi Select list box.

    So I want the button the clear all criteria, from my list box.

  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: Clearing List Box Selection

    Try this.
    Please Login or Register  to view this content.
    Or this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Clearing List Box Selection

    Try:-
    Please Login or Register  to view this content.
    Regards Mick

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

    Re: Clearing List Box Selection

    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.

  5. #5
    Forum Contributor
    Join Date
    01-04-2016
    Location
    Newcastle
    MS-Off Ver
    2016
    Posts
    107

    Re: Clearing List Box Selection

    Works brilliant, thanks

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

    Re: Clearing List Box Selection

    Just kind of wondering, what suggestion worked for you?

  7. #7
    Forum Contributor
    Join Date
    01-04-2016
    Location
    Newcastle
    MS-Off Ver
    2016
    Posts
    107

    Re: Clearing List Box Selection

    Bit of a late reply but i used your solution, never tried the others. Thanks

+ 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. Replies: 4
    Last Post: 07-06-2017, 10:19 AM
  2. Selecting and clearing a Specific Range within an Active Selection
    By AustinR in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-02-2015, 01:19 PM
  3. [SOLVED] Setting list index of drop down list, or clearing them ?
    By Lukael in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-30-2014, 01:08 PM
  4. Clearing data when i change selection on drop down lists
    By MarioLamaa in forum Excel General
    Replies: 2
    Last Post: 08-08-2013, 04:50 AM
  5. [SOLVED] Clearing cell contents that meet certain criteria for a very large selection
    By Pippin66 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2012, 09:42 PM
  6. Issue clearing previous selection
    By nmutimer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-25-2006, 08:31 AM
  7. clearing a selection
    By John in Surrey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2005, 07:10 AM

Tags for this Thread

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