• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need layout based on drop down value.

abhisharma

New Member
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.
 

Attachments

Logit

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

https://www.exceltip.com/tips/how-to-filter-the-data-based-on-the-selection-of-cell-using-vba-in-microsoft-excel-2010.html

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

Sample:

Code:
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
 
Top