SELECT Multiple Items in Dropdown List with VBA!

Channel:

Office Expert

Subscribers:

49,300

Published on November 28, 2024 12:00:00 AM ● Video Link: https://www.youtube.com/watch?v=v8nO51FtazI

Duration: 0:00

1,010 views

64

Practice File: https://1drv.ms/x/c/4c05b1926392fda7/EbhjhO2WVjdDurJ_K20b9RwBx2u-KsKEE3qaACAYbvE3xA?e=F8EMbf
--------------------------------------------------------------------------------------
Dim selectedItems As String

Private Sub Worksheet_Change(ByVal Target As Range)
Dim dropdownRange As Range
Set dropdownRange = Range("A1") ' Change "A1" to the cell with the dropdown list

' If the changed cell is the dropdown cell
If Not Intersect(Target, dropdownRange) Is Nothing Then
Application.EnableEvents = False

' Store the previous selection
If selectedItems = "" Then
selectedItems = Target.Value
Else
' If the selected value is not already in the list, add it
If InStr(1, selectedItems, Target.Value) = 0 Then
selectedItems = selectedItems & ", " & Target.Value
Else
' If the selected value is already in the list, remove it
selectedItems = Replace(selectedItems, Target.Value, "")
selectedItems = Replace(selectedItems, ", ,", ",")
End If
End If

' Update the cell with the selected items (concatenated list)
Target.Value = selectedItems

Application.EnableEvents = True
End If
End Sub
--------------------------------------------------------------------------------------
Learn how to SELECT Multiple Items in Dropdown List with VBA in Excel! In this tutorial, we'll show you a step-by-step guide on how to use Visual Basic for Applications (VBA) to select multiple items in a dropdown list in Excel. This is a common problem that many Excel users face, and we'll provide you with a simple and effective solution using VBA. By the end of this video, you'll be able to select multiple items in a dropdown list with ease, making your work in Excel more efficient and productive. VBA is a powerful tool that can help you automate tasks and improve your workflow, and this video is a great starting point for learning more about its capabilities. So, if you're ready to take your Excel skills to the next level, watch this video now and learn how to select multiple items in a dropdown list with VBA!
--------------------------------------------------------------------------------------
For more tips tricks and videos, visit our Website: https://www.techaicenter.com/
Join our Tech Community on:
♪ Tiktok: https://www.tiktok.com/@techai71
Facebook: https://www.facebook.com/techaipro22/
𝕏 Twitter: hhttps://x.com/TechAi_CenterInstagram:  https://www.instagram.com/techaicenter1/
We'd love to hear from you if you have any questions or collaboration proposals!
📧 Our Email: TechAiCenter@gmail.com