Select Multiple Items In Drop Down List At A Time In Excel || Feedback Education 2.0 скачать в хорошем качестве

Select Multiple Items In Drop Down List At A Time In Excel || Feedback Education 2.0

Select multiple items in drop down list at a time in Excel || Feedback Education 2.0 If you like this video, Please subscribe my channel, like, share and comment for more more videos update. VBA Code:👇👇👇 Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Newvalue As String Application.EnableEvents = True On Error GoTo Exitsub If Target.Address = "$C$2" Then If Target.SpecialCells(xlCellTypeAllValidation) Is Nothing Then GoTo Exitsub Else: If Target.Value = "" Then GoTo Exitsub Else Application.EnableEvents = False Newvalue = Target.Value Application.Undo Oldvalue = Target.Value If Oldvalue = "" Then Target.Value = Newvalue Else If InStr(1, Oldvalue, Newvalue) = 0 Then Target.Value = Oldvalue & ", " & Newvalue Else: Target.Value = Oldvalue End If End If End If End If Application.EnableEvents = True Exitsub: Application.EnableEvents = True End Sub #dropdown #dropdownmenu #excel #feedbackeducation #dropdownlist Feedback Education 2.0 Social Media Link: E-mail: feedbackeducation.in@gmail.com Instagram: Sanjay.4u Thanks for watching.......!!!!! Keep Supporting My Channel.