Multiple Select Cases - VBA

**VCarver** · 09-06-2022, 06:05 AM

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.

**Phuocam** · 09-06-2022, 06:36 AM

Try this code


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$15" Then
Select Case Range("F15").Value
...
End Select
ElseIf Target.Address = "$F$53" Then
Select Case Range("F53").Value
...
End Select
End If
End Sub

**CheeseSandwich** · 09-06-2022, 06:38 AM

If you remove the trailing spaces off of the data that makes up your drop down values then the below will work:

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim rRow As Long
    
    If Not Intersect(Target, Range("F15,F53")) Is Nothing Then
        If Target.Address = "$F$15" Then
            Rows("17:45").Hidden = True
            rRow = Range("C17:C45").Find(Target.Value).Row
            Rows(rRow & ":" & rRow + 3).Hidden = False
        ElseIf Target.Address = "$F$53" Then
            Rows("55:83").Hidden = True
            rRow = Range("C55:C83").Find(Target.Value).Row
            Rows(rRow & ":" & rRow + 3).Hidden = False
        End If
    End If
End Sub

**VCarver** · 09-06-2022, 07:01 AM

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

Multiple Select Cases - VBA

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Multiple Select Cases - VBA

Re: Multiple Select Cases - VBA

Re: Multiple Select Cases - VBA

Re: Multiple Select Cases - VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Issue with Multiple cases in same sub

Select cases if cell empty or contains range

[SOLVED] Select case where value is numeric then select other cases

[SOLVED] Building multiple Select Cases

Add cases opened and closed for each month and specifics about the cases.

[SOLVED] How to use formula to select those cases that meet some criteria?

Select Cases and Comboboxes

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions