Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel Drop Down List Autocomplete Entries (Add the Code (Copy the Code in…
Excel
Drop Down List
Autocomplete Entries
1
If the worksheet is protected,
allow users to Edit Objects,
and they will be able to use
the combobox
Review > Protect Sheet > Check Edit Object
3
Create a dropdown list
4
Add a combo box
Developer > Design Mode > Insert > Combo Box
Open
Properties Window
Change the Properties
Name the Combo Box
Change the Font and Font Size
Set the Number of Rows
Turn on AutoComplete
MatchEntry > 1-frmMatchEntryComplete
2
Set up the Workbook
Name the Sheets
Check the Zoom Level
IMPORTANT:
Keep both sheets at the same
zoom setting, to avoid crashing Excel
Type the Lists
Add the Code
Copy the Code in the folder Templates
Right Click the worksheet and click View Code
Paste the Code and close
Save file as xlsm file