+ Reply to Thread
Results 1 to 4 of 4

Multiple Select Cases - VBA

  1. #1
    Registered User
    Join Date
    09-06-2022
    Location
    Redhill, England
    MS-Off Ver
    365
    Posts
    5

    Post Multiple Select Cases - VBA

    Good morning all,

    I am trying to construct a worksheet whereby it hides multiple rows based on certain data in cells restricted to a data validation list.

    Attachment 794997

    Can't quite seem to get it over the line.

    Example enclosed, but ultimately need rows to hide based on value in cells F15 and F53 at the same time.

    An assist would be most welcome. Any questions, let me know.

    Thanks in advance for any replies.
    Attached Files Attached Files
    Last edited by VCarver; 09-06-2022 at 07:02 AM. Reason: Resolved

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,915

    Re: Multiple Select Cases - VBA

    Try this code

    Please Login or Register  to view this content.

  3. #3
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2404-17531.20128
    Posts
    1,361

    Re: Multiple Select Cases - VBA

    If you remove the trailing spaces off of the data that makes up your drop down values then the below will work:
    Please Login or Register  to view this content.
    If things don't change they stay the same

  4. #4
    Registered User
    Join Date
    09-06-2022
    Location
    Redhill, England
    MS-Off Ver
    365
    Posts
    5

    Re: Multiple Select Cases - VBA

    RESOLVED - Both approaches work! Thank you both, much appreciated!

+ 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] Issue with Multiple cases in same sub
    By mjb0810 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2021, 08:54 AM
  2. Select cases if cell empty or contains range
    By Karen57 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-17-2018, 03:52 AM
  3. [SOLVED] Select case where value is numeric then select other cases
    By scottiex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2015, 11:03 PM
  4. [SOLVED] Building multiple Select Cases
    By Tortus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-01-2015, 08:43 AM
  5. Add cases opened and closed for each month and specifics about the cases.
    By ChrisLaRoc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-04-2014, 08:19 PM
  6. [SOLVED] How to use formula to select those cases that meet some criteria?
    By BNCOXUK in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-27-2012, 08:20 AM
  7. Select Cases and Comboboxes
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2011, 11:13 PM

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