need layout based on drop down value.

[abhisharma]

Hi Team,

I need VBA macro which display the layout based on drop down value.

I am attaching the excel , in this excel i have sheet1 there i made one drop down.

If i select the value Simple it should display the layout with two users details only.

Please find excel sheet attached.

I have mentioned the details in excel as well.

 

[Logit]

The process of FILTERING based on the content of a DROP DOWN value is what you are seeking.

https://www.exceltip.com/tips/how-t...f-cell-using-vba-in-microsoft-excel-2010.html

https://www.listendata.com/2014/12/excel-vba-filter-data-based-on-drop.html

Sample:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Dim rownumber As Integer

rownumber = ActiveCell.Row

    If Application.Intersect(ActiveCell, [headers]) Is Nothing Then

        If ActiveCell.Value<> "" Then

Range("A1:D13").Interior.ColorIndex = xlNone

Range("A" &rownumber& ":D" &rownumber).Interior.ColorIndex = 6

        End If

    End If

End Sub