How to Create A Multi-Select Drop-Down List in Excel

HOW TO CREATE A MULTI-SELECT DROP-DOWN LIST IN EXCEL - Employee Termination Checklist Template // Learn to setup a drop-down list in Excel that allows users to make multiple selections. This method uses some VBA code that places the selected items on new lines within the drop-down cell. The example form used in this video is an Employee Termination Checklist that allows the manager filling in the form to select multiple items from an issued equipment list that they have retrieved from an exiting employee.

The template from this video is available for download for a minimal fee and here is a link if you are interested in purchasing it (thanks for supporting my channel!): https://www.etsy.com/listing/883544110/employee-termination-checklist-form?ref=listing_published_alert

TIP: If you use Macros (VBA code) in your document, make sure your IT department allows the use of Macros, otherwise users may have issues opening the document. Remember to save your document as a Macro-Enabled file type (.xlsm).

Here is the VBA code we used in the video:

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 = "$A$10" Or Target.Address = "$D$10" 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 & vbNewLine & Newvalue
Else:
Target.Value = Oldvalue
End If
End If
End If
End If
Application.EnableEvents = True
Exitsub:
Application.EnableEvents = True
End Sub
__________
RESOURCES & GEAR
✦ Screen Recording Software: https://techsmith.z6rjha.net/NZG5b
✦ Green Screen: https://amzn.to/2DnHsY2
✦ Camera: https://amzn.to/39KvpQA
✦ PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=
Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
__________
NOTE: If you found this content helpful, please consider donating to my channel from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS:
✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
CONNECT WITH ME:
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
__________
KEYWORDS: #MSExcel, #M365, How To Create Fillable Forms in Excel, How To Create Drop-Down List in Excel, How To Create a Form in Excel, Link Text to Drop-Down Using IF Formula, Link Text to Drop-Down Using VLOOKUP, Insert Checkboxes in Excel, How To Hide Worksheet Tabs in Excel, Employee Engagement Survey Template, How To Hide Spreadsheet in Excel, How To Hide Workbook in Excel, How to Unhide Very Hidden Tabs in Excel, Excel Fillable Forms, Excel Tutorial, Excel Lesson, Excel Tips and Tricks, Sharon Smith HR, @SharonSmithHR
__________
PLAYLISTS:
➤Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

➤PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR

Видео How to Create A Multi-Select Drop-Down List in Excel канала Sharon Smith