+ Reply to Thread
Results 1 to 3 of 3

Multi Selection Listbox used to hide rows on a sheet

  1. #1
    Registered User
    Join Date
    08-27-2014
    Location
    Scotland
    MS-Off Ver
    2007 and 2010
    Posts
    2

    Multi Selection Listbox used to hide rows on a sheet

    Amatuer here needing some help with the following; The objective is a worksheet with a pre-determined list of items on it which the user can select via a multi-selection listbox.
    Once the desired items are selected a button is clicked which closes the list box and hides the selected rows on the sheet.
    The reason I want to hide the rows is so than they can be unhidden thereby restoring the full list if need be, and a new selection made.
    The code I have come up with through my limited knowledge and research has got me reading the data from the listbox into an array but I can't work out the rest.
    Any help or alternative suggestions are greatfully received.

    Thanks in advance

    Wheels723
    Attached Files Attached Files
    Wheels

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

    Re: Multi Selection Listbox used to hide rows on a sheet

    Hide button does as you require.
    Restore button works in reverse select in listbox those rows you wish to restore.
    torachan.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-27-2014
    Location
    Scotland
    MS-Off Ver
    2007 and 2010
    Posts
    2

    Re: Multi Selection Listbox used to hide rows on a sheet

    Thank you so much.
    Guess I was over thinking the problem, that is so straight forward and just what I need for the people using the workbook (not entirely excel literate).
    Thanks again great solution.

+ 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. Get Multi Selection Listbox userform and clear all selection
    By jp16 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2018, 10:43 AM
  2. pop-up multi-selection listbox
    By capson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2016, 06:10 PM
  3. [SOLVED] Listbox macro to hide/unhide rows in different sheet
    By dgibney in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2014, 02:01 PM
  4. Replies: 4
    Last Post: 07-24-2012, 07:09 AM
  5. Multi Selection Listbox
    By protocol in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-18-2011, 03:14 AM
  6. 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
  7. [SOLVED] Multi Selection in a ListBox
    By Claus Mygind in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2005, 11:06 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